Take col1 and col3 in pipeline with a sequece generator, and sorted value

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

3 Answers
6524 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.

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is data caches/ index caches?

1108

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9145

Explain pushdown optimization and types in informatica

1081

Mention few power centre client applications with their basic purpose?

953

What is workflow monitor?

1063

What is persistent lookup cache?

1035

How to join three sources using joiner?

1119

What are Dimensional table?

1061

What are the databases that informatica can connect to windows?

1056

Explain the pipeline partition with real time example?

1144

What is the need of etl tools?

1121

Differences between version 7.x and 8.x.

1899

What is sorter transformation?

1051

What is deployment group?

1219

What is expression transformation?

1107