Design a mapping to get year of join for each employee.
Answer Posted / abhinaw prakash
We can use Date Conversion function to find out the Year and
use SUBSTR function to extract that particular year.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How can a transformation be made reusable?
Explain lookup transformation is active in informatica
what is unit testing?tell me proceedure
How to create the source and target database connections in server manager?
Design a mapping to load a target table with the following values from the above source?
What is the difference between informatica 7.0 and 8.0?
What is the difference between router and filter?
Define mapplet?
EXL informatica Questions
have u done any performance tuning? how u ll do?
What are the modules in Power Center
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
What is the benefit of partitioning a session?
What is the function of look up transformation?