Design a mapping to get year of join for each employee.
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Reusable transformation and shortcut differences
What is the difference between informatica 7.0 and 8.0?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the different transaction levels available in transaction control transformation?
Explain about cumulative Sum or moving sum?
On which transformations you created partitions in your project?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
can you please explain me pre session and post session options?
How to convert multiple rows to single row (multiple columns) in informatica
Can we create multiple integration service on single repository?
Do you find any difficulty while working with flat files as source and target?
Can u generate reports in Informatica?
What is dynamic cache?
What is the Process to creating lookup transformation in informatica