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 are the types of caches in lookup?
What are the advantages of using informatica as an etl tool over teradata?
What is meant by target load plan?
What is the maplet?
tell me the rules and responsblites in our project(my project is development)
Explain what are the different types of transformation available in informatica.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can we handle two sessions in informatica?
What are the tasks that can be performed using sq?
How to load last n records of file into target table - informatica
What is the difference between a connected look up and unconnected lookup?
What are the databases that informatica can connect to windows?
Write the advantages of partitioning a session?
Mention few advantages of router transformation over filter transformation.
Explain pushdown optimization $pushdownconfig parameter - informatica