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 / 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 |
Post New Answer View All Answers
What is a repository manager?
Explain direct and indirect flat file loading (source file type) - informatica
write a query to retrieve the latest records from the table sorted by version(scd)
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is the Default Source Option For Update Strategy Transformation?
have u done any performance tuning? how u ll do?
How to partition the Session?
Differentiate between a repository server and a powerhouse?
Define update strategy?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain sessions?
Is there any target staging area in informatica not staging area
Explain the different kinds of facts.
permutations of mapplet
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not