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
- 16779 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 are testing in a mapping level please give brif eplanation
How to enter same record twice in the target table,explain?
Differentiate between Load Manager and DTM?
How are parameters defined in informatica?
What are the types of metadata that stores in repository?
How will you combine 3 different sources with a single source?
What are the unsupported repository objects for a mapplet?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
What are the types of lookup?
What is a joiner transformation and why it is an active one?
In which scenario did you used pushdown optimization?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Teradata 
