i have one table like cust_id ph1 ph2 ph3 10

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/

Question Posted / rv

4 Answers
7207 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have one table like cust_id ph1 ph2 ph3 1002 92901235..

Answer / ghouse

cus_id ph
1002 9290123526
1002 9767192210
1002 9876545232

Is This Answer Correct ?

2 Yes

0 No

i have one table like cust_id ph1 ph2 ph3 1002 92901235..

Answer / mehul thakur

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

i have one table like cust_id ph1 ph2 ph3 1002 92901235..

Answer / surendra

Please give the exact requirement

Is This Answer Correct ?

0 Yes

0 No

i have one table like cust_id ph1 ph2 ph3 1002 92901235..

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

Post New Answer