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
- 7403 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 |
How to do Integration testing in Informatica?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
how do u fnd the duplicate rows and how to delete the duplicate rows?
While migrating the data from one environment to another environment how would you manage the connections?
what is the need of session partitioning... how it is useful in real time
How to do unit testing in informatica?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
where is the reject loader .
How mapping parameter and variable works
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Explain the aggregator transformation?
Can we insert ,update ,delete in target tables with one update strategy tran.?
Teradata 
