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
- 16771 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
Explain the pipeline partition with real time example?
What is resilience time?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is aggregate cache in aggregator transformation?
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?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the surrogate key?
What is incremental aggregation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Write the different tools in the workflow manager?
How will the document be delivered to me?
what is unit testing?tell me proceedure
COM components can be used in Informatica
Explain in detail scd type 2 through mapping.
