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


Please Help Members By Posting Answers For Below Questions

Explain where to store informatica rejected data? How to extract the informatica rejected data?

831


What are the mapping parameters and mapping variables?

843


How do you take back up of repository?

931


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

831


To import the flat file definition into the designer where should the flat file be placed?

854


How do you load only null records into target?

964


How are the sources and targets definitions imported in informatica designer?

881


Where can we find the throughput option in informatica?

852


Can u generate reports in Informatica?

850


Mention few advantages of router transformation over filter transformation.

844


What are the performance considerations when working with aggregator transformation?

923


How to start a workflow using pmcmd command?

946


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2140


Where do we use mapping variables in informatica?

826


How to join three sources using joiner? Explain though mapping flow.

908