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

Answer / galandekapil

I think we can do this via declaring 3 variables say var1,
var2 and var3 in an expression transformationand say we
have 3 input columns col1, col2 and col3.
var1=max(col1, col2, col3)
var2=IIF(var1=col1 and col2>col3, col2,
else if var1=col1 and col3>col2, col3,
else if var1=col2 and col1>col3, col1,
else if var1=col2 and col3>col1, col3,
else col3
var3=min(col1, col2, col3)

Then assign var1 to target col1, var2 to target col2 and
var3 to target col3. I guess this way we can sort the date
in row.

Answer / vasu

Benz
if we follow like that , we couldn't get the remains
column's data order,surely that will change.

if u get another ,let me know

Answer / guest

Need to connect to the normalizer transformation and ther
put occurs in the normalizer properties

Answer / ram

use sort for col2

Answer / benz

order by clause

Select * from tablename orderby col2 asc;

What is sq transformation?

0 Answers  

How will you combine 3 different sources with a single source?

3 Answers  

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

tell me about your project functionality

0 Answers  

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

What is the status code in stored procedure transformation?

0 Answers   Informatica,

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,