In a sequential batch can you run the session if previous
session fails?
Answer Posted / sankar
YES
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what are 3 tech challenges/ common issues you face?
How can we update a record in the target table without using update strategy?
How can we store previous session logs?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Could you explain what is enterprise data warehouse?
Explain the use of aggregator cache file?
Repository user profiles
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?
Explain the types of lookup transformation?
have u done any performance tuning? how u ll do?
What is transformation?
What are the differences between source qualifier and joiner transformation?
What are the types of lookup transformation?