Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 9802 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / rahul
In Informatica use aggrigator on group by Col1 Col2 Col3.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Enlist some properties of sessions.
What is the maplet?
What are the advantages of using informatica as an etl tool over teradata?
What is deployment group?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can we create a Integration service without a Repository service and vice versa?
Is it possible to use a client with different version than that of its Informatica server?
How to generate sequence numbers without using the sequence generator transformation?
Can we get 1st record through Informatica(without sequence number).
What are the measure objects?
is it possible to index the data in cache of lkp transformation ?
What is update strategy transform?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What does update strategy mean, and what are the different option of it?
Mention a few design and development best practices for informatica?
