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

Answers were Sorted based on User's Feedback



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

Answer / praveen kumar pendekanti

use

decode function in Expression taking one new column as Flag


iif is_null(column_name,-NA-,column_name)

Is This Answer Correct ?    14 Yes 1 No

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

Answer / 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

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

Answer / abidu

Write 'not applicable' as the default in the expression
transformation.

Is This Answer Correct ?    1 Yes 1 No

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

Answer / yaseen

with the help of ISNULL() function of the Informatica...

Is This Answer Correct ?    1 Yes 4 No

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

Answer / 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

More Informatica Interview Questions

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,


What is complex mapping?

0 Answers  


in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,


What is the need of an ETL tool?

0 Answers   Informatica,


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


permutations of mapplet

0 Answers   TCS,


What are the different options available for update strategy?

0 Answers  


Is there any way to read the ms excel datas directly into informatica?

0 Answers  


Why we use lookup transformations?

1 Answers  


Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  


Categories