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/
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 |
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Different types of Power center errors?
What is event and what are the tasks related to it?
Target increases every day even though no new record was inserted
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 is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
Explain Dataware house architecture .how data flow from intial to end?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
How many cubes create from a single model?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION