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
- 0 Answers
- 1417 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
why normalizer transformation can not used in mapplet? plzzzz answer
What is the cumulative sum and moving sum?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a filter transformation and why it is an active one?
Can yoU use the maping parameters or variables created in one maping into another maping?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What is the Router transformation?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What are events in workflow manager?
explain about lookup t/r?
Teradata 
