Interested to Buy Any Domain ? << Click Here >> for more details...
how can we calculate fact table size?
- 1 Answers
- 6344 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 |
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
Mention few advantages of router transformation over filter transformation.
how to load dimension table and fact table. plz tell me the steps.
Explain transaction control transformation in informatica
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
What is Java Transformation? what are the uses of it?
What do you understand by term role-playing dimension?
In real time scenario where can we use mapping parameters and variables?
WHat all joins are there in Source Qualifier?
Write the unconnected lookup syntax and how to return more than one column.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Teradata 
