Interested to Buy Any Domain ? << Click Here >> for more details...
What is facttable granularity?
- 2 Answers
- 8204 Views
- I also Faced
- E-Mail Answers
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 |
Is it possible to update the target table with PK?
Define enterprise data warehousing?
How to delete duplicate records in a flat file source?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the types of lookup transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to create Target definition for flat files?
How we can use union transformation?
What are 2 modes of data movement in Informatica Server?
What is difference between Mapplet and reusable transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Teradata 
