Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
- 1 Answers
- 2868 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between extension & intension?
Can you tell any two advantages of stored procedures?
How is image stored in database?
Under which circumstance should you create an index on a table?
Give the syntax of exception handling used in DBMS?
Explain data independence & its types.
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
How default key is different from primary key?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
what is tkprof tool and how it is used???
What is sharded database?
What are the advantages of normalizing a database.
