Hi I have data warehouse implementation for Click Stream data analysis on RDBMS. Its a start schema (Dimensions and Facts).
Now if i want to move to Hive, Do i need to create same data model as Dimensions and facts and join them. I should create a big de-normalized table which contains all textual attributes from all dimensions. If so how do we handle SCD 2 type dimensions in Hive. Its very basic question but I am just confused on this. Thanks, Kuldeep
