A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Answer Posted / abidu
Write 'not applicable' as the default in the expression
transformation.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a sequence generator transformation?
Enlist few areas or real-time situations where informatica is required.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the static cache and dynamic cache in informatica?
Do you find any difficulty while working with flat files as source and target?
What all are steps in up gradation of Informatica server?
How can we delete duplicate rows from flat files?
What are the uses of etl tools?
Explain the types of transformations?
How do you load unique records into one target table and duplicate records into a different target table?
What are the main issues while working with flat files as source and as targets ?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is domain and gateway node?
What are the main features of Oracle 8i with context to datawarehouse?
How can one identify whether mapping is correct or not without connecting session?