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 / rahul
use sorter trans
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is rank transform?
Did u used latest transformations of 8.6.0? for what?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is domain in terms of informatica?
Explain the pipeline partition with real time example?
how to create user defined function (udf) in informatica
Differentiate between Load Manager and DTM?
What is different between the data warehouse and data mart?
Enterprise data warehouse your projects phase by phase explain?
What is informatica etl tool?
pmscmd startworkflow -sv
What is a stored procedure transformation?
What are the different types of repositories created using informatica?
Parameter and variable differences