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 |
Explain the etl program with few examples.
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
How to delete duplicate record in Informatica?
How can you increase the performance in joiner transformation?
How can you define user defied event?
What are the options in the target session of update strategy transsformatioin?
how to convert the .doc docs into .txt format using informatica
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
What is the Rankindex in Ranktransformation?
what is data driven?
What is xml source qualifier transformation in informatica?
What are the diffrences between joiner transformation and source qualifier transformation?