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
- 9663 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivas kondeti
SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
scenario where i can use only concurrent execution of workflow.
When do you use sql override in a lookup transformation?
How to do the error handling of if ur source is flatfiles?
Describe the impact of several join conditions and join order in a joiner transformation?
How to implement security measures using repository manager?
Explain the different dimensions.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the function of union transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is workflow manager?
Clarify the aggregator change?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
