Design a mapping to get year of join for each employee.
Answer Posted / abdul
can we use GET_DATE_PART Function?
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain dynamic target flat file name generation in informatica
Define update strategy?
What is the use of transformation?
Performance tuning( what you did in performance tuning)
what is the Default Source Option For Update Strategy Transformation?
What if the source is a flat-file?
Explain the different dimensions.
What are ETL Tools?
what is SDLC way of code development?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a surrogate key?
Explain pushdown optimization and types in informatica
How can informatica be used for an organization?