Interested to Buy Any Domain ? << Click Here >> for more details...
What is facttable granularity?
- 2 Answers
- 8081 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 |
What is an aggregator transformation? it is active why cant it be passive explain?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
how u know when to use a static cache and dynamic cache in lookup transformation.
In a table, 4 person having same salary. How to get Third person record only?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
When do you use mapping parameters? (In which transformations)
Please let me know how to make Data masking in informatica..
Teradata 
