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
- 8788 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
In which transformation you cannot drag ports into it?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
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 are the conditions needed to improve the performance of informatica aggregator transformation?
What is data movement mode in Informatica and difference between them?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
can we override a native sql query within informatica? Where do we do it? How do we do it?
How can we remove the duplicates from flat file source?
What is Session and Batches?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Can we create two repositories on same database instance in oracle?
What is a repository manager?
What are some examples of informatica etl programs?
What is an aggregator transformation?
How do you convert single row from source into three rows into target?
