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

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

Question Posted / durgaprasad

2 Answers
6700 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / durgaprasad

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

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Plz can any one say me how to get the informatica certification materials and dumps

2035

Enterprise data warehouse your projects phase by phase explain?

1909

How do we call shell scripts from informatica?

1091

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4719

What is the need for an etl tool?

1055

How will the document be delivered to me?

1064

permutations of mapplet

2492

can anyone suggest best free Talend data integration training online

1684

Explain lookup transformation in informatica

1051

What is the session task and command task?

1034

What's the layout of parameter file (what does a parameter file contain?)?

2373

How to start a workflow using pmcmd command?

1226

How can informatica be used for an organization?

1200

Design time, run time. If you don't create parameter what will happen

1828

How to do unit testing in informatica?

1162