A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
- 5 Answers
- 15890 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 are the different lookup cache(s)?
Can we create a Integration service without a Repository service and vice versa?
Enlist the tasks for which source qualifier transformation is used.
How do you manage the Parameter files while migrating your data from one environment to another environment?
Enlist the differences between database and data warehouse.
How do you promote a non-reusable transformation to reusable transformation?
What differs when we choose the sorted input for aggregator transformation?
Can we create two repositories on same database instance in oracle?
can anyone explain me about retail domain project in informatica?
What is workflow? What are the components of the workflow manager?
What is the use of target designer?
What are active and passive transformations?
Differentiate between a database and data warehouse?
What is the fact table?
What is meant by lookup transformation? Explain the types of lookup transformation?
