rajneeshshukla
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by rajneeshshukla
-
Hello All, I am wondering about Gather Statistics strategies for a Data warehouse being built from scratch. Any guideline and suggestion will be great? For example: It is very essential after first time initial load, essential for large volume of transaction records load etc Recommendations may help me to define frequency for same. Thanks, Rajneesh
-
Hello Experts, OLTP source tables are having surrogate keys (numeric values) and natural keys (alphanumeric values), then can I skip creating surrogate keys in target OLAP DB (Dimensional Model) for dimension tables. I know that I will need surrogate keys for fact tables as uniquke key for fact table will be a large set and I will need a single columns with numeric values as primary key there. I am joining mutiple source tables for populating data into one dimension target then I am wondring to use unique id (numeric values) of driving table (this id is inherited from OLTP source) as primary key , provided that data granularity of resulted record is at driving tables' id level (resulted record is the record after main source driving table is joined with other source tables). What will be benefit of surrogate key in data warehosue layer? Thanks, Rajneesh
-
Hello Experts, What kind of indexes are recommended for staging area in ETL flow. For example unique index on natural key columns. I have surrogate key as well in data flowing in from source. Also any suggestion/recommendation for indexing in other layers like dimensional data model layer and type 1 persistent data layer for full snapshot data. Thanks, Rajneesh
