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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gd
sq-->Sorter t/r--->target
In sorter check the sorted port for col2 with ASC.
Is This Answer Correct ? | 0 Yes | 2 No |
How the facts will be loaded? explain
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
What is a command that used to run a batch?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
How we can confirm all mappings in the repository simultaneously?
How to delete first 3 rows & last 3 rows in target table in informatica
what is difference between COM & DCOM?
What is persistent lookup cache?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
What happens when a session fails and you click on recover?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Differentiate between a database and data warehouse?