Which tool yoU use to create and manage sessions and batches
and to monitor and stop the informaticaserver?
Answer Posted / swetha
Informatica server manager.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
What are the different transaction levels available in transaction control transformation?
What are the tasks that can be performed using sq?
What is the fact table?
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 is sorter transformation?
What is Index Caches size?
What is the function of look up transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to load data in informatica ?
How do we call shell scripts from informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do you update the records with or without using update strategy?
What are the differences between oltp and olap?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?