Answer Posted / swetha
Connected and unconnected
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
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.
How to differentiate between the active and passive transformations?
What happens when a session fails and you click on recover?
What is a router transformation?
What are different types of transformations available in informatica?
What is the function of aggregator transformation?
How can you differentiate between powercenter and power map?
How can repository reports be accessed without sql or other transformations?
Design a mapping to load a target table with the following values from the above source?
What are the modules in Power Center
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?