Interested to Buy Any Domain ? << Click Here >> for more details...
Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
- 1 Answers
- 3551 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
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is the difference between database and server?
Explain storage manager?
What do you mean by cluster and non cluster index?
How do I setup a database connection?
What are different types of resources?
What are the various ways to execute a query in teradata?
what are wrappers and build ups and what it's use?
What are the advantages of normalizing a database.
Explain entity ?
Explain database partitioning.
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What is the best database software for small businesses?
Explain various types of locks in a transaction? Which is better and why?
Data structure used to implements a menu:
