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
- 1404 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
How can we get multiple output values using an unconnected lookup transformation?
If you want to create indexes after the load process which transformation you choose?
How to use pmcmd utility command?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
what is the process we used in joiner transformation,there is no matching column in sources?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
can we have to do changes in session property when we are dynamically generating target files?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
why union is active transformation?
can anyone explain me about sales project in informatica?
Teradata 
