Answer Posted / venkateshmalneni
A fact table is multiple of combination of dimension tables
ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores
3*365*200*200=fact table size
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Define mapping and session?
Explain the features of connected and unconnected lookup.
Performance tuning in UNIX for informatica mappings?
What are the restrictions of union transformation?
Enterprise data warehouse your projects phase by phase explain?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Different sorts of metadata that stores in the storage facility?
What are the differences between source qualifier and joiner transformation?
What is a joiner transformation and why it is an active one?
What is meant by query override?
explan ur project architecture?
What does update strategy mean, and what are the different option of it?
How might one distinguish in the case of mapping is right or not without associating session?
what is size of u r database?
