Design a mapping to get year of join for each employee.

Answers were Sorted based on User's Feedback



Design a mapping to get year of join for each employee...

Answer / abdul

can we use GET_DATE_PART Function?

Is This Answer Correct ?    7 Yes 0 No

Design a mapping to get year of join for each employee...

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

Design a mapping to get year of join for each employee...

Answer / ram

use TO_DECIMAL(TO_CHAR(COLUM,'YYYY'))

Is This Answer Correct ?    3 Yes 1 No

Design a mapping to get year of join for each employee...

Answer / ganesh reddy

use expression t/r in exp write to_char(hiredate,'yyyy')

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,


Difference Between ETL & ELT?

1 Answers   TCS,


What is a configuration management?

1 Answers  


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?

0 Answers  






Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  


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

0 Answers   IBM,


What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  


what is INFORMATICA TESTING process

0 Answers  


How is Data Models Used in Practice?

1 Answers  


What is the difference between router and filter?

0 Answers  


how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,


Categories