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
- 1907 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is joiner transformation?
what is session override?
How many ways are there to create ports?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the two modes of datamovement in informatica sever?
Briefly define a session task?
What is parameter file?
Explain the different kinds of facts.
What are limitations of joiner transformation?
Types of error logs in Informatica?
what is parameter file?
Teradata 
