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;

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

How to partition the Session?

0 Answers   Informatica,

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

How can you access the remote source into your session?

1 Answers  

Define Pmrep command?

0 Answers  

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

What is the difference between a router and a filter transformation?

1 Answers   TCS,

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,