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
Explain what is batch and describe about types of batches?
How to pivot data using informatica when you have variable amount of pivot rows?
How can we run the graph?
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
What is edw?
Explain reference cursor?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is Star Schema?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Describe the differences between a data warehouse and data mart.
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
I know of using applysimple, but there are other ways too?
What is the difference between aggregate table and materialized view?
What is the difference between view filter and report filter?
What is pre-emptive and non-pre-emptive?