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

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

what are the limitation of sorter transformation?

2 Answers   TCS,

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,

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

What is confirmed dimension?

3 Answers  

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

What are the data movement modes in informatcia?

1 Answers  

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories