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/
Answer Posted / 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 |
Post New Answer View All Answers
What is an active transformation?
Explain lookup transformation in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is a difference between complete, stop and abort?
Reusable transformation and shortcut differences
How to handle decimal places while importing a flatfile into informatica?
Difference between Data and Index Caches?
What are the performance considerations when working with aggregator transformation?
What is the difference between a repository server and a powerhouse?
What is union transformation in informatica?
Define filter transformation?
What differs when we choose the sorted input for aggregator transformation?
What is workflow? What are the components of workflow manager?
What are ETL Tools?
Can we get 1st record through Informatica(without sequence number).