Answer Posted / guest
After you gather all the relevant information about the
subject area, the next step in the design process is to
determine the granularity of the fact table. To do this you
must decide what an individual low-level record in the fact
table should contain. The components that make up the
granularity of the fact table correspond directly with the
dimensions of the data model. Thus, when you define the
granularity of the fact table, you identify the dimensions
of the data model.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is repository manager?
How to load the data from people soft hrm to people soft erm using informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Which development components of informatica have the highest usage?
Explain sessions. Explain how batches are used to combine executions?
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. ?
Can we create multiple integration service on single repository?
What is event and what are the tasks related to it?
What is decode in static cache?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the different transaction levels available in transaction control transformation?
What is the status code in stored procedure transformation?
Why do you use Mapping Parameter and mapping variable?
Mention few advantages of router transformation over filter transformation.
What is a filter transformation?