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?
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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is the need of an ETL tool?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the Rank index port in Rank transformation?
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
How to Create a folder using pmrep command?
What could be the possible resons of locks by user?
what is mean by complex business rule ?
What does role playing dimension mean?
Design time, run time. If you don't create parameter what will happen
Different qualification between a related rotate toward the sky and isolates look upward?
Where are the source flat files kept before running the session?
Mention few advantages of router transformation over filter transformation.
How would you copy the content of one repository to another repository?
What is the surrogate key?