Design a mapping to get year of join for each employee.
Answer Posted / ganesh reddy
use expression t/r in exp write to_char(hiredate,'yyyy')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the mapping parameters and mapping variables?
What do you mean by blocking transformation?
What is parallel processing in informatica?
can anyone suggest best free Talend data integration training online
What does command task mean?
What is informatica?
Differentiate between router and filter transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
According to his methodology what all you need before you build a datawarehouse
expain about the tune parameters?
What is a predefined event?
What is an expression transformation in informatica?
How to create the source and target database connections in server manager?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?