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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different lookup cache(s)?

824


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

775


What could be the possible resons of locks by user?

857


What are different types of transformations available in informatica?

756


How would you copy the content of one repository to another repository?

772


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1850


In which transformation you cannot drag ports into it?

1046


What are the different ways to implement parallel processing in informatica?

1107


Explain the different lookup methods used in informatica?

798


What is target designer and target load order?

851


What are the differences between source qualifier and joiner transformation?

813


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1868


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1670


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

824


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

851