Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

What are the uses of etl tools?

0 Answers  

What is meant by a domain?

0 Answers  

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

What is the function of union transformation?

0 Answers  

What is mapplet and a reusable transformation?

2 Answers  

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

For more Informatica Interview Questions Click Here
Categories