Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?

Answers were Sorted based on User's Feedback



Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i wa..

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.

Is This Answer Correct ?    4 Yes 0 No

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i wa..

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.

Is This Answer Correct ?    2 Yes 0 No

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i wa..

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

Is This Answer Correct ?    0 Yes 0 No

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i wa..

Answer / guest

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

Is This Answer Correct ?    0 Yes 1 No

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i wa..

Answer / ram

use sort for col2

Is This Answer Correct ?    4 Yes 6 No

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i wa..

Answer / benz

order by clause

Select * from tablename orderby col2 asc;

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More Informatica Interview Questions

What is a transaction control transformation?

0 Answers   Informatica,


My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,


What is the need of etl tools?

0 Answers  


what is data driven?

1 Answers  


what type of problem you faced insales project or insurance project

1 Answers   Sony,






My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


What are Business Components in Informatica?

1 Answers  


What is native users?

0 Answers  


What do you mean by enterprise data warehousing?

0 Answers  


What are the basic needs to join two sources in a source qualifier?

3 Answers  


what is the monster dimension plz give me one example

2 Answers   EDS,


Categories