Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?
Answer Posted / guest
Need to connect to the normalizer transformation and ther
put occurs in the normalizer properties
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What all join we can perform in LOOKUP transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Where do we use mapping variables in informatica?
Write the different tools in the workflow manager?
What is the commit type if you have a transaction control transformation in the mapping?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to Create a folder using pmrep command?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is event and what are the tasks related to it?
Explain about Informatica server process that how it works relates to mapping variables?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is a sorter transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N