Design a mapping to get year of join for each employee.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ganesh reddy
use expression t/r in exp write to_char(hiredate,'yyyy')
Is This Answer Correct ? | 0 Yes | 0 No |
why do we go for update strategy tr in SCD rather using the session properties?
what is data driven in update strategy transformation?
Difference Between ETL & ELT?
What is a configuration management?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is meant by lookup transformation? Explain the types of lookup transformation?
what is INFORMATICA TESTING process
How is Data Models Used in Practice?
What is the difference between router and filter?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.