it is so simple write a query like this SELECT MAX(A),MAX(B),MAX(C),MAX

I am hvaing SOURCE as
1000,null,null,null
null,2000,null,null
null,null,3000,null
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 / kondeti srinivas

5 Answers
10021 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / kondeti srinivas

it is so simple
write a query like this

SELECT MAX(A),MAX(B),MAX(C),MAX(D) FROM TABLE_NAME

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are Dimensional table?

1120

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1915

what are factless facts? And in which scenario will you use such kinds of fact tables.

1855

How can repository reports be accessed without sql or other transformations?

1268

define galaxy repository in informatica

2285

How is union transformation utilized?

1059

What are the measure objects?

1255

What are active and passive transformations?

1129

How are indexes created after completing the load process?

1718

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

1892

What are the main features of Oracle 8i with context to datawarehouse?

2159

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1079

What is the use of source qualifier?

1184

Sequence generator, when you move from develoment to production how will you reset

2122

What is the benefit of session partitioning?

1157