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

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

How do you recover rows from a failed session

1 Answers  

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

What does command task mean?

0 Answers  

why we use stored procedure transformation?

4 Answers   IBM,

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

in which situations do u go for sequence generator ?

2 Answers   TCS,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

What is the use of an aggregator cache file?

0 Answers  

how we do performence tuning in informatica

3 Answers  

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

For more Informatica Interview Questions Click Here
Categories