Hi@ sukumar balla If the goal of the star schema is to provide analytics to the end user, you could also consider advanced BI tools like Platfora for data discovery, analytics & reporting. It integrates nicely with data stored in Hadoop and leverages its computational abilities, i.e. does a lot of the processing in YARN. Platfora provides an interest driven workflow where the raw data of interest is pulled into a 'lens' cutting down the time it takes to ETL/ELT using traditional Pig/Hive scripts. This is done via a web interface making analytics accessible to a large group of users in the organisation. Additionally, the lens building process is agile due to Platfora firing Spark jobs in the background using the Hadoop cluster to build the lens. The end users can draw pixel perfect reports/charts using drop zones on the Vizboards in little time. Cheers, Kiran.
... View more