Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is facttable granularity?

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


Please Help Members By Posting Answers For Below Questions

What is repository manager?

1026


How to load the data from people soft hrm to people soft erm using informatica?

1067


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1382


Which development components of informatica have the highest usage?

1099


Explain sessions. Explain how batches are used to combine executions?

1080


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2086


Can we create multiple integration service on single repository?

1240


What is event and what are the tasks related to it?

1203


What is decode in static cache?

1262


What is the difference between STOP and ABORT options in Workflow Monitor?

1311


What are the different transaction levels available in transaction control transformation?

1274


What is the status code in stored procedure transformation?

1232


Why do you use Mapping Parameter and mapping variable?

1808


Mention few advantages of router transformation over filter transformation.

1069


What is a filter transformation?

1092