Interested to Buy Any Domain ? << Click Here >> for more details...
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
- 5 Answers
- 16545 Views
- HP, I also Faced
- E-Mail Answers
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 |
What is the difference between STOP and ABORT options in Workflow Monitor?
when informatica 8 series released ?
how can u avoid duplicate rows in flat file?
How to eliminate duplicate records in informatica mapping? Explain with an example....
Repository user profiles
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
why we use materialized view over view?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the different types of schemas?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
Teradata 
