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
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is exclusive and normal mode for repository services?
Explain the code page compatibility?
server hot-ws270 is connect to Repository B. What does it mean?
Could you explain what is enterprise data warehouse?
Explain the types of transformations?
What is pmcmd command?
How to create the source and target database connections in server manager?
What are the transformations that are not supported in mapplet?
How many transformations can be used in mapplets.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
COM components can be used in Informatica
Explain lookup transformation source types in informatica
what are the Methods For Creating Reusable Transformations?