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
6603 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

Why do you use Mapping Parameter and mapping variable?

1705

How to generate sequence numbers using expression transformation?

1040

can we override a native sql query within informatica? Where do we do it? How do we do it?

1025

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1240

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1971

What is an unconnected transformation?

1046

What is a predefined event?

1054

What is a transaction control transformation?

1158

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1099

permutations of mapplet

2470

What is the session task and command task?

1006

What is the use of target designer?

1001

In warehouses how many schemas are there?

1029

What is confirmed fact in dataware housing?

6853

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2268