I have source data like this
col1 col2 col3
5 3 8
6 2 9
7 1 10
and i want to get target as
col1 col2 col3
5 1 8
6 2 9
7 3 10
which transformation i have to use and how?
Answer Posted / siva
Take col1 and col3 in pipeline with a sequece generator,
and sorted values of col 2 in another pipeline with
sequence generator. Join both pipelines by sequence values
and send it to target.
for more details.. look into 5th page, last question, last
answer
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Describe an informatica powercenter?
What can we do to improve the performance of informatica aggregator transformation?
What is meant by a domain?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is the size of your data warehousing?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the advantages of informatica?
What are the guidelines to be followed while using union transformation?
What is informatica metadata and where is it stored?
While migrating the data from one environment to another environment how would you manage the connections?
How do you update the records with or without using update strategy?
How can informatica be used for an organization?
What are the different types of olap? Give an example?
What are the components of Informatica? And what is the purpose of each?
What is repository manager?