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
- 9825 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 is decode in static cache?
Difference between Target-based loading and constraint-based loading?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is mapping debugger?
which one is better performance wise joiner or look up
What are the types of presistent cache in look up tr.
what is $$$$?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is Index Caches size?
What all are steps in up gradation of Informatica server?
What is the function of union transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What is the fact table?
How to load the data from people soft hrm to people soft erm using informatica?
What are the limitations of joiner transformation?
