Interested to Buy Any Domain ? << Click Here >> for more details...
i have one table like
cust_id ph1 ph2 ph3
1002 9290123526 97671927210 9876545232
we use Normalizer wt is o/p?
sue normalizer we can generate three tables in single table/
- 4 Answers
- 7276 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ghouse
cus_id ph
1002 9290123526
1002 9767192210
1002 9876545232
| Is This Answer Correct ? | 2 Yes | 0 No |
In normalizer tab of normalizer tr. set no of occurence to 3
since we have 3 phno,which in turn create 3 i/p port in port tab,u hav to create exp tr. betn normalizer and target and map GCID_phno to expression tr. say out_phno and give condition in expression like decode(GCID_phno,1002,9290123526,1002,97671927210,1002,9876545232);
It might help u
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / subash
Hi Ghouse,
Can u pls explain how we achieve this, the logic in
normalizer, is it by just connecting the output ports from
normalizer to target , where we define ph1 occcuring 3 times
in normalizer transformation. Do we have to use any
expression transformation between the normalizer and the
target. Can some one who tried please explain the logic that
happens in normalizer transformation in splitting a single
row into multiple tuples
| Is This Answer Correct ? | 0 Yes | 0 No |
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What is transformation?
What are the new features in Informatica 5.0?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
How can you define user defied event?
Explain direct and indirect flat file loading (source file type) - informatica
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Parameter and variable differences
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
How to elaborate powercenter integration service?
What is the difference between procedure and stored procedur?
Teradata 
