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
- 1822 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
what are the differences between powercenter 8.1 and powercenter 8.5?
can any one explain me about junk dimension
Explain the pipeline partition with real time example?
What is log file,and where is it located,why u r using the log file
how can we perform incremental aggregation?explain with example?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are pre and post-session shell commands?
What is source qualifier?
what is the necessity to use update strategy?(except for updates)
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Teradata 
