What is facttable granularity?
Answers were Sorted based on User's Feedback
Answer / sri ram
The level of details to be stored in fact table is termed
as granularity.
Eg: for a Retail store, the granularity for sales fact is
as that of Point Of Sales i.e., each transaction occurs,
the data is stored in the fact table.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What does update strategy mean, and what are the different option of it?
What is incremental aggregation?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Why is meant by direct and indirect loading options in sessions?
what is shared Cache. when we will use shared Cache?
What is substr in informatica?
whatis the default data driven operation in informatica
hw cn v elimate dublicate values from lookup without overriding sql?
What is the use of target designer?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
What is data merging, data cleansing and sampling?
Write the unconnected lookup syntax?