Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 6485 Views
- I also Faced
- E-Mail Answers
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
what is song in infrmatica...?
What are the types of caches in lookup? Explain them.
What is intricate mapping?
How to join three sources using joiner? Explain though mapping flow.
How to start a workflow using pmcmd command?
What is informatica etl tool?
What do you understand by SOA of Informatica?
What is lookup transformation?
How might you approve all mappings in the archive all the while?
What do you mean by blocking transformation?
How do we call shell scripts from informatica?
What is the function of look up transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what are 3 tech challenges/ common issues you face?
How you prepared reports for OLAP?
