A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

Answer Posted / bsgsr

hi, praveen

gud afternoon,
cool ans and clear explanation.
i am srinivas trying for a break on informatica.
i love xchange of knowledge to nrich further.
my mail id: bsgsr12@gmail.com
mail me if interested.

bye,
srinivas

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of olap? Give an example?

553


How to load last n records of file into target table - informatica

593


Explian the Process of deployment groups in informatica

650


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

603


What is meant by lookup transformation? Explain the types of lookup transformation?

562






Could you explain what is enterprise data warehouse?

549


What is the function of look up transformation?

644


What is status code in informatica?

575


Differences between version 7.x and 8.x.

1413


explain one complex mapping with logic? sales project?

6135


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1737


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1642


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1584


What is flashback table ? Advance thanks

1476


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8525