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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is facttable granularity?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is facttable granularity?..

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

What is facttable granularity?..

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

Post New Answer

More Informatica Interview Questions

How do you load first and last records into target table?

0 Answers  

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

difference between stop and abort

2 Answers  

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

Scheduling properties,whats the default (sequential)

0 Answers  

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

Differentiate between router and filter transformation?

0 Answers  

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

What are the new features of informatica 9.x developer?

0 Answers  

What is degenerated dimention table?

7 Answers   Patni,

For more Informatica Interview Questions Click Here
Categories