Answer Posted / seshagiri k
A dimension which can be shared with multiple fact tables
OR
A dimension which can be used by one or more fact tables is
called confirmed dimension
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is an unconnected transformation?
What are batches?
Define mapping and session?
how many types of dimensions are available in informatica?
EXL informatica Questions
Define mapplet?
In warehouses how many schemas are there?
How do you set a varible in incremental aggregation
What is a router transformation?
What is dimensional table?
wf dont have integration severances how you can run?
How does the aggregator transformation handle null values?
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.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Write the prerequisite tasks to achieve the session partition?