What is the difference between Power Centre and Power Mart?
Answer Posted / giri
Power Center Power Mart
------------ -----------
1.Local and Global Local Repository
Repository
2.Session Partition available Session Partition Not
available
3.24 transformation available 16 transformation available
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Reusable transformation and shortcut differences
What is informatica worklet?
How are indexes created after completing the load process?
What are different types of transformations available in informatica?
COM components can be used in Informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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.
Informatica settings are available in which file?
Can we get 1st record through Informatica(without sequence number).
Explain how to import oracle sequence into informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to do unit testing in informatica? How to load data in informatica ?
lookup transformation with screenshots
What is a surrogate key?