how can we calculate fact table size?
- 1 Answers
- 5525 Views
- I also Faced
- E-Mail Answers
A fact table is multiple of combination of dimension tables
ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores
3*365*200*200=fact table size
| Is This Answer Correct ? | 3 Yes | 2 No |
What are the challenges of Dataware housing in the future?
How the informatica server increases the session performance through partitioning the source?
Mention a few design and development best practices for informatica?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
What are the scheduling options to run a sesion?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Slowly changing dimensions, types and where will you use them
how to work with mapplet designer in informatica?
In Which scenario did u used Incremental loading?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
what is song in infrmatica...?
What is meant by query override?
Teradata 
