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
- 16740 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 a code page?
What is primary and backup node?
What are the transformations that are not supported in mapplet?
Clarify the aggregator change?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Describe expression transformation?
What is depict expression change?
What are pre and post-session shell commands?
Could you explain what is enterprise data warehouse?
What is a repository manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the types of lookup transformation?
Briefly explain the aggregator transformation?
What is the meaning of decode in informatica?
How to Create a folder using pmrep command?
