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


Please Help Members By Posting Answers For Below Questions

What do you mean by enterprise data warehousing?

649


How many input parameters can exist in an unconnected lookup?

1003


What is data movement mode in Informatica and difference between them?

627


What is a filter transformation and why it is an active one?

564


Is there any target staging area in informatica not staging area

2132






What is enterprise data warehousing?

616


What are the different clients of powercenter?

602


Can informatica load heterogeneous targets from heterogeneous sources?

698


Define mapping and session?

587


What are multi-group transformations?

566


What is the difference between a connected look up and unconnected lookup?

578


What is decode in static cache?

596


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?

794


What are the restrictions of union transformation?

582


How we can create indexes after completing the load process?

616