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
- 8870 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
What is intricate mapping?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a dimensional model?
What is complex mapping?
How union transformation is used?
How to do the error handling of if ur source is flatfiles?
What is data movement mode in Informatica and difference between them?
What are the main issues while working with flat files as source and as targets ?
I have a flat file, want to reverse the contents of the flat file
Performance tuning in UNIX for informatica mappings?
EXL informatica Questions
What is the difference between STOP and ABORT options in Workflow Monitor?
Differentiate between reusable transformation and mapplet.
How to elaborate tracing level?
what is SDLC way of code development?
