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
How you prepared reports for OLAP?
What is union transformation in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
During the running session, output files are created by informatica server. Enlist few of them.
Is stop and abort are same in informatica?
What is meant by pre and post session shell command?
How do you manage the Parameter files while migrating your data from one environment to another environment?
how we can load rejected record's at run time?(not through bad files)
explain one complex mapping with logic? sales project?
How many dimensions are there in informatica?
How to delete duplicate row using informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Why update strategy and union transformations are active? Explain with examples.
Explain sessions. Explain how batches are used to combine executions?