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

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,


AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,


Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,


What is a data modeling?

2 Answers  


what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,






What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  


When the informatica server marks that a batch is failed?

1 Answers  


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,


Categories