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
- 9661 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
what are factless facts? And in which scenario will you use such kinds of fact tables.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the meaning of decode in informatica?
What are the new features of informatica 9.x developer?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain Dataware house architecture .how data flow from intial to end?
What is aggregate cache in aggregator transformation?
What is a difference between complete, stop and abort?
wat are deployement groups in informatica, how it will be used for developers
Explain about Informatica server process that how it works relates to mapping variables?
What are the uses of etl tools?
What are the tuning techniques you applied during your last project
Define joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
draw informatica architecture 8.6 ?
