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

how to create user defined function (udf) in informatica

772

How can you differentiate between powercenter and power map?

611

What is the sql query overwrite in source qualifier in informatica

607

Scheduling properties,whats the default (sequential)

1452

Quickly characterize reusable change?

677

Explain the use of aggregator cache file?

665

Explain the types of transformations?

588

Explain what transformation and how many are there in informatica?

476

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

622

Differentiate between reusable transformation and mapplet.

558

what is mean by complex business rule ?

1710

What is target load order?

795

What is incremental aggregation?

565

Can we override a native sql query within informatica?

620

Why is sorter an active transformation?

653