A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
- 5 Answers
- 14919 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / praveen kumar pendekanti
use
decode function in Expression taking one new column as Flag
iif is_null(column_name,-NA-,column_name)
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is enterprise data warehousing?
What is the need of etl tools?
Why filter transformation is an active one?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the guidelines to be followed while using union transformation?
How to load data in informatica ?
Explain about cumulative Sum or moving sum?
Tell me about Propagate functions in informatica
What is expression transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the difference between a connected look up and unconnected lookup?
What are the components of workflow manager?
Separate from a database, an information bazaar, and an information stockroom?
How can we delete duplicate rows from flat files?
