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
- 7527 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 |
Howmany ways yoU can update a relational source defintion and what are they?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What differs when we choose the sorted input for aggregator transformation?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
In how many ways we can create ports?
How many joins in Informatica
what is the exact meaning of domain?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
How can we create index after completion of load process?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
Teradata 
