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
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 |
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 |
Answer / abidu
Write 'not applicable' as the default in the expression
transformation.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / yaseen
with the help of ISNULL() function of the Informatica...
Is This Answer Correct ? | 1 Yes | 4 No |
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 |
Without using Lookup & Sequence Generator, How to generate Sequence?
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 ??
What is a data modeling?
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?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
When the informatica server marks that a batch is failed?
What is the way to execute pl/sql script using informatica mapping?
How to load last 10 records of flat file in to the target?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
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.