sq-->Sorter t/r--->target In sorter check the sorted port for col2

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 / gd

3 Answers
6530 Views
I also Faced
E-Mail Answers

Answer Posted / gd

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

In sorter check the sorted port for col2 with ASC.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2170

write a query to retrieve the latest records from the table sorted by version(scd)

1077

What are the different types of olap? Give an example?

1059

How to create a non-reusable instance of reusable transformations?

1138

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1178

What is an Integration service in Informatica?

1143

Did u used latest transformations of 8.6.0? for what?

1888

What is pmcmd command?

1132

what is SDLC way of code development?

2047

What is a code page?

1183

What is joiner transformation in informatica?

1054

What is rank transformation?

997

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1135

Explain the features of connected and unconnected lookup.

938

What are the different components of powercenter?

1056