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
- 9712 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
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to go to the older version for a mapping?
What are active and passive transformations?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How would you copy the content of one repository to another repository?
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 are the restrictions of union transformation?
What is rank transformation in informatica
how tokens will generate?
How do you promote a non-reusable transformation to reusable transformation?
What is an expression transformation in informatica?
What is the session task and command task?
In warehouses how many schemas are there?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to extract the informatica rejected data?
