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 the difference between aggregate table and fact
table ? how do you load these two tables ?

Answer Posted / jayalakshmi

fact table is one which contains all the facts
(measures).aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.

Is This Answer Correct ?    14 Yes 50 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is batch and describe about types of batches?

1080


How to pivot data using informatica when you have variable amount of pivot rows?

901


How can we run the graph?

1060


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2500


What is edw?

1192


Explain reference cursor?

2163


How to join 3 database like flat file, oracle, db2 in informatrica?

1224


What is Star Schema?

1108


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

956


Describe the differences between a data warehouse and data mart.

995


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2263


I know of using applysimple, but there are other ways too?

959


What is the difference between aggregate table and materialized view?

1098


What is the difference between view filter and report filter?

919


What is pre-emptive and non-pre-emptive?

972