Interested to Buy Any Domain ? << Click Here >> for more details...
supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How
- 4 Answers
- 14967 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rajesh bathini
seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
What is a shortcut and copy in Informatica and how two are different with each other?
What do mean by local and global repository?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain pmcmd command usage in informatica
What is Data Caches size?
What is mapping debugger?
Where can we find the throughput option in informatica?
How you prepared reports for OLAP?
what are 3 tech challenges/ common issues you face?
How do you load unique records into one target table and duplicate records into a different target table?
Which development components of informatica have the highest usage?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How many transformations can be used in mapplets.
