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
- 6646 Views
- I also Faced
- E-Mail Answers
Answer Posted / gd
sq-->Sorter t/r--->target
In sorter check the sorted port for col2 with ASC.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
What is a rank transform?
What is standalone command task?
difference between informatica 8.1.1 and 8.6
Explain pushdown optimization and types in informatica
What is the difference between router and filter?
What are session parameters ? How do you set them?
Differences between connected and unconnected lookup?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What's the layout of parameter file (what does a parameter file contain?)?
How can we create index after completion of load process?
What is DR strategy for Informatica project?
Can we get 1st record through Informatica(without sequence number).
How do you migrate data from one environment to another?
Separate from an archive server and a powerhouse?
