A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Answer Posted / sri ram
In the column properties sheet, write N/A in the Default
value text box for the particular column
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
What is dynamic cache?
Which transformation should we use to normalise the COBOL and relational sources?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain lookup transformation is active in informatica
What are the different components of powercenter?
How would you join a node to the already existing domain?
Differentiate between sessions and batches?
What is exclusive and normal mode for repository services?
What is aggregate cache in aggregator transformation?
What is a difference between complete, stop and abort?
Design a mapping to load a target table with the following values from the above source?
What does refresh system mean, and what are its distinctive choice?
What is joiner transformation in informatica?
How to join three sources using joiner? Explain though mapping flow.