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
What are the different lookup cache(s)?
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?
What could be the possible resons of locks by user?
What are different types of transformations available in informatica?
How would you copy the content of one repository to another repository?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
In which transformation you cannot drag ports into it?
What are the different ways to implement parallel processing in informatica?
Explain the different lookup methods used in informatica?
What is target designer and target load order?
What are the differences between source qualifier and joiner transformation?
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
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?