1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

write a query to remove null value follwing table?
col1 col2 col3
dinesh null null
null suresh null
null null prakesh

i want the output

col1 col2 col3
dinesh suresh prakesh

Question Posted / dinesh

Answers were Sorted based on User's Feedback



write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / srinivas kondeti

SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM

Is This Answer Correct ?    11 Yes 1 No

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / chandrasekar

Hi Srinivas how the sql query execute because the query
returns only max values.. so please clarify.

Is This Answer Correct ?    1 Yes 1 No

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / sasibushan

This will work

SELECT Max(CASE WHEN col1 IS NOT NULL THEN col1 END) AS "col1",
Max(CASE WHEN col2 IS NOT NULL THEN col2 END) AS "col2",
Max(CASE WHEN col3 IS NOT NULL THEN col3 END) AS "col3"
FROM Table_name

Convert this logic to Informatica...

Sasi.

Is This Answer Correct ?    1 Yes 1 No

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / rahul

In Informatica use aggrigator on group by Col1 Col2 Col3.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

What is the difference between router and filter?

0 Answers  

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,




How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

Explain the code page compatibility?

0 Answers  

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

Define joiner transformation?

0 Answers  

What is confirmed dimension?

3 Answers  

.prm wirh repalce .txt is possible?

2 Answers  

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

For more Informatica Interview Questions Click Here
Categories