Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
Answer / pratap
Th Aggregate tables will always have higher granularity than the fact table. The grain of aggregate table can be derived from one key or combination of multiple keys from within the fact table.
Is This Answer Correct ? | 0 Yes | 0 No |
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
What is the differnce between Order by and Group by
List the properties of a transaction.
What is the advantage of varchar2 over char?
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What are indexes in oracle?
a __________ is a virtual table made up of subset of actual table
Explain storage manager?
What are the advantages of using database?
CLI stands for?
What will happen non-clustered index will be created on clustered index?