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 are the types of caches in lookup?

978


What are the advantages of using informatica as an etl tool over teradata?

973


What is meant by target load plan?

917


What is the maplet?

1041


tell me the rules and responsblites in our project(my project is development)

1875


Explain what are the different types of transformation available in informatica.

1039


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1994


How can we handle two sessions in informatica?

985


What are the tasks that can be performed using sq?

1026


How to load last n records of file into target table - informatica

1022


What is the difference between a connected look up and unconnected lookup?

911


What are the databases that informatica can connect to windows?

1003


Write the advantages of partitioning a session?

1210


Mention few advantages of router transformation over filter transformation.

982


Explain pushdown optimization $pushdownconfig parameter - informatica

1081