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
What are the different types of olap? Give an example?
How to load last n records of file into target table - informatica
Explian the Process of deployment groups in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is meant by lookup transformation? Explain the types of lookup transformation?
Could you explain what is enterprise data warehouse?
What is the function of look up transformation?
What is status code in informatica?
Differences between version 7.x and 8.x.
explain one complex mapping with logic? sales project?
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 ?
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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is flashback table ? Advance thanks
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?