I am hvaing SOURCE as first line: 1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 For more clarification i
want to elimate nulls and want in a single line. Please
help me out

Answers were Sorted based on User's Feedback



I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd li..

Answer / durgaprasad

select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;

Is This Answer Correct ?    7 Yes 0 No

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd li..

Answer / srinivas

Just load the flat file.
(1000,null,null,null
null,2000,null,null
null,null,,3000,null
null,null,null,4000)
Go with Aggregate Trans formation with
MAX(field1)
MAX(field2),,,, .

Pls let me know if any corrections srinu.srinuvas@gmail.com

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More Informatica Interview Questions

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  


What you know about transaction control transformation?

0 Answers  


I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  






Please let me know how to make encryption and decryption with example?

0 Answers  


how do u tune queries?

1 Answers  


Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  


Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,


how to obtain performance data for individual transformations.

2 Answers  


In informatics server which files are created during the session rums?

0 Answers  


difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,


Categories