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
- 8682 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 workflow? What are the components of workflow manager?
What is substr in informatica?
What is a snowflake schema?
define galaxy repository in informatica
What is joiner transformation in informatica?
What are the different versions of informatica?
What is meant by query override?
What is an unconnected transformation?
Explain the different dimensions.
What is rank transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different types of repositories created using informatica?
explain abt ur project architecture?
What is session task and command task?
What is a joiner transformation and why it is an active one?
