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
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
How many ways are there to create ports?
Where do we use mapping variables in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the format of informatica objects in a repository?
Why update strategy and union transformations are active?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is persistent lookup cache?
Which files are created during the session rums by informatics server?
What are the different types of olap? Give an example?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is rank transformation in informatica