Badges
40 Points
5 Years
User Activity
Over 4 years ago
Answered a question: bitmap index as preferred choice in data warehousing environment
Bitmap indexes are useful for low cardinality column(s) for 3 primary reasons: 1. Rowid bit map value of indexed values are stored together, making faster access for group data access 2. Bitmap Indexes saves space 3. Bit mapping where 2 or more bitmap indexes can be…
Over 4 years ago
Answered a question: What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
Here are some of the advantages of managing data in different layers
1. Provides logical separation of data between different layers
2. For any maintenance of each layer such as backup or recovery or data model change apply, etc. are layer dependent
3. From data security…
Over 4 years ago
Answered a question: Are there any general guidelines to allocate table space quota to different layers in ETL?
Space requirement will be directly dependent on design considerations and data requirements. Any estimation without detailed information is bound to be faulty and should be used as reference only
Here are my recommendation on how to go about it:
1. Staging
Estimating…
About 5 years ago
Contributed a review of Teradata: Improves processing speed and enhances data protection
Projects
Reviews
Answers
Over 4 years ago
Cloud Data Warehouse
Over 4 years ago
Cloud Data Warehouse
Over 4 years ago
Cloud Data Warehouse
Interesting Projects and Accomplishments
About 5 years ago