source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
Answer Posted / kiran
USE SOTER TR . IN SORTER TR CLICK ON DISTINCT OPTION IT ELIMINATE THE DUPLICATE AS WELL AS SORT THE ORDER.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is lookup transformation?
Explain your project of banking domian.
What is informatica powercenter repository?
How to implement security measures using repository manager?
What are the different types of repositories created using informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How can you define user defied event?
What is a sequence generator transformation?
scenario where i can use only concurrent execution of workflow.
if we have a delimiters at unwanted places in a flat file how can we over come those.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How an expression transformation differs from aggregator transformation?
How to extract sap data using informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is decode in informatica?