Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 11064 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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 status code in informatica?
What is mapplet in informatica?
What is an unconnected transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the types of presistent cache in look up tr.
What is informatica? Why do we need it?
What are the transformations that are not supported in mapplet?
What is the difference between writing a joiner query in ANSI style and THETA style?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How would you copy the content of one repository to another repository?
Explain what is informatica metadata and where is it stored?
What is Data Caches size?
How to handle decimal places while importing a flatfile into informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
