Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?
- 6 Answers
- 8895 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.
Eg: seq col1 col3
1 5 8
2 6 9
3 7 10
Seq Col2
1 1
2 2
3 3
after joining
col1 col2 col3
5 1 8
6 2 9
7 3 10
I think that resolves your problem.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
How do you handle two sessions in Informatica
Enlist the tasks for which source qualifier transformation is used.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can you define user defied event?
How do you set a varible in incremental aggregation
In warehouses how many schemas are there?
What is expression transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we handle two sessions in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How to configure mapping in informatica?
Explain joiner transformation in informatica
explain one complex mapping with logic? sales project?
What is a code page?
