Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1867 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
What is native users?
What are the session parameters?
What are the different types of code pages available in informatica & how to implement it in your project?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Write the unconnected lookup syntax?
in realtime which situations u can use unconnected lookup transformation
What do you mean by blocking transformation?
how to calculate the optimum cache size in aggregator transformation?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
Teradata 
