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;

Define Incremental Aggregation?

2 Answers  

List the transformation in informatica.

1 Answers   TCS,

What is the benefit of partitioning a session?

0 Answers  

what is filelist concept in informatica

4 Answers  

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

How can we create index after completion of load process?

0 Answers  

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

What is source qualifier?

6 Answers   SDS,

What is difference between a connected look up and unconnected look up?

6 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers