Hi,
I saw one mapping implemented by my seniors . In Expression
transformation they implemented following logic. That is
iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y
YYYMMDD'),'Inventory Date is either invalid or null')
Inventory_Date is validated only for is_date()
But not validated for notisnull() .
But error says “ either invalid or null “ why?
Whether is_date() also check for not isnull() ? or in this
logic something is different ?
Please answer me .
Advance thanks
- 1 Answers
- 1939 Views
- IBM, I also Faced
- E-Mail Answers
Answer / Prem Datt
The 'is_date()' function checks if the input value can be converted into a date format, but it does not check if the input value is null. If the input value is null, 'is_date()' will return false. However, in your expression, you are using the 'iif()' function which first evaluates the condition (in this case, 'is_date()'). Since the condition returned false for a null value, the second part of the 'iif()' function is executed, which returns 'Inventory Date is either invalid or null'. If you want to check if the input value is not null before checking if it is a valid date, you can use the 'not isnull()' function first and then apply 'is_date()'.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of transformation available in informatica.
What is data merging, data cleansing and sampling?
How can we eliminate duplicate rows from flatfile,explain?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
explain one complex mapping with logic? sales project?
1 Answers Accenture, JPMorgan Chase,
what is the mechanism of the Master-Detail joining condition?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
What are the types of error logs available in Informatica?
What is a standalone command task?
What is mapplet and a reusable transformation?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Teradata 
