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
- 1804 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Define update strategy?
Which means the first record should come as last record and last record should come as first record and load into the target file?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What are the tasks that can be performed using sq?
What is a candidate key?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Why we use partitioning the session in informatica?
What are the types of maping wizards that r to be provided in Informatica?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
which one is better either active or passive transformation in informatica
Teradata 
