Interested to Buy Any Domain ? << Click Here >> for more details...
What is facttable granularity?
- 2 Answers
- 8258 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 |
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Router T/R is active but some people are saying it is also passive which is exactly right?
what is system requirement(SR) & business requirement(BR)?
what are the real time problems generally come up while doing or running mapping or any transformation?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
What is the benefit of session partitioning?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
without matching columns in two tables. how can you join
what is mean by grouping of condition column in lookup transformation?
Teradata 
