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?
Answer Posted / 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 |
Post New Answer View All Answers
What is the benefit of partitioning a session?
Can u generate reports in Informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the surrogate key?
Scheduling properties,whats the default (sequential)
What do you mean incremental aggregation?
In informatica workflow manager, how many repositories can be created?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain your project of banking domian.
What is pmcmd command?
What is the difference between Active and Passive transformation?
waht type of interface is used for testing the data in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Can we override a native sql query within informatica?