Interested to Buy Any Domain ? << Click Here >> for more details...
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 the different lookup cache(s)?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a passive transformation?
What are the components of workflow manager?
what is diff b/t sorter t/r and agg have the option sorter property...
Write the different tools in the workflow manager?
Differences between version 7.x and 8.x.
What is a mapplet/worklet in informatica?
What are the databases that informatica can connect to windows?
How to improve the performance of a session using sorter transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Under what condition selecting sorted input in aggregator may fail the session?
How do you convert single row from source into three rows into target?
How can we use batches?
