I have source data like this col1 col2 col3 5 3 8 6 2 9 7

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?

Question Posted / rajani.pichka

3 Answers
5473 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want ..

Answer / 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.

for more details.. look into 5th page, last question, last
answer

Is This Answer Correct ?

1 Yes

1 No

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want ..

Answer / gd

sq-->Sorter t/r--->target

In sorter check the sorted port for col2 with ASC.

Is This Answer Correct ?

0 Yes

2 No

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want ..

Answer / rahul

use sorter trans

Is This Answer Correct ?

0 Yes

4 No

Post New Answer