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

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / ranjan

5 Answers
16590 Views
HP, I also Faced
E-Mail Answers

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