A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
- 5 Answers
- 15828 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by active and passive transformation?
What is blocking transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is informatica metadata?
What is incremental aggregation?
What is the Process to creating lookup transformation in informatica
Differentiate between joiner and lookup transformation?
What is update strategy transform?
What is domain in terms of informatica?
What do mean by local and global repository?
Mention a few design and development best practices for informatica?
What is rank transformation in informatica
How do you load first and last records into target table?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
