A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
- 5 Answers
- 15921 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / abidu
Write 'not applicable' as the default in the expression
transformation.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why sorter is an active transformation?
What is mapplet in informatica?
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?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is an unconnected transformation?
Explain the aggregator transformation?
What is pmcmd command?
What is enterprise data warehousing?
What are the types of caches in lookup?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
what is informatica metadata?
How can we use mapping variables in informatica? Where do we use them?
What are the advantages of informatica?
Why do we need informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
