The Source coloumns are A,B,C with data row1- 10,20,30 row2-
40,50,60 row3-70,80,90 and so on. In the target I want one
coloumn with the following data, Coloumn-X, row1-10,row2-
20,row3-30,row4-40,row5-50 and so on. How to achieve this?
Answers were Sorted based on User's Feedback
Answer / babu
Hi All,
By using Normalizer Transformation we will achive this.
Mapping:
========
Src==>SQ==>Nrm(Normalizer)==>Srt(sorter)==>Trg
Nrm:Column(Occerence 3)
Column1 (inputport)
Column2 (inpuport)
Column3 (inputport)
Column (outputport)===> Srt ==>Trg
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / swapnil
no need to use normalizer here, take 3 expression and 3
instance of target.
Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
Make 3 instances of the target. Connect port from exp_1 to
target_1. Connect port from exp_2 to target_2 and connect
port from exp_3 to target_3.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / kuldeep singh rathore
Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
and we merge all output of all 3 expressions by UNION trans
and direct load to tgt from union
| Is This Answer Correct ? | 0 Yes | 0 No |
how do u fnd the duplicate rows and how to delete the duplicate rows?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
In warehouses how many schemas are there?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What is decode in informatica?
what are the output files that the informatica server creats during running a session?
How can u work with remote database in informatica?did you work directly by using remote connections?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
how can we use sorter transformation in joins?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
difference between stop and abort