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 do you mean by enterprise data warehousing?
How many input parameters can exist in an unconnected lookup?
What is data movement mode in Informatica and difference between them?
What is a filter transformation and why it is an active one?
Is there any target staging area in informatica not staging area
What is enterprise data warehousing?
What are the different clients of powercenter?
Can informatica load heterogeneous targets from heterogeneous sources?
Define mapping and session?
What are multi-group transformations?
What is the difference between a connected look up and unconnected lookup?
What is decode in static cache?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the restrictions of union transformation?
How we can create indexes after completing the load process?