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 |
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
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What is complex mapping?
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?
What is the need of an ETL tool?
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.
permutations of mapplet
What are the different options available for update strategy?
Is there any way to read the ms excel datas directly into informatica?
Why we use lookup transformations?
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?