Skip to main content
Christ
Christ
Silver ⭐️
December 21, 2021
Question

Data Warehouse Use Case

Hi,

 

I have a background in traditional data warehousing (SQL, 3NF Inmon, Star schema Kimball). I used to design data models then create it in a SQL RDMS and then populate it with ETL data flows. Paying a particular attention to slowly changing dimensions.

 

With Cloudera, how to build the equivalent of a data warehouse? and which feeding treatments? What are the components to use?

 

Thanks.

7 replies

shehbazk
Gold ⭐️⭐️
shehbazk
Gold ⭐️⭐️
June 15, 2022

Hi @Christ,

 

Thanks for being a part of the Cloudera community,

 

  1. CDP Public Cloud Data Warehouse 
  2. CDP Private Cloud Data Warehouse 

You can leverage the above options provided by Cloudera for the Public and Private clouds.

 

Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

Translate
shehbazk
Gold ⭐️⭐️
shehbazk
Gold ⭐️⭐️
June 21, 2022

Hi @Christ 

 

If your issue has been resolved, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

Translate
Christ
ChristAuthor
Silver ⭐️
June 22, 2022

Thanks for the reply. It looks to me interesting but does not tell about best practices of architecture and data modeling. For example, it would be great to add a diagram in your documentation illustrating architecture: components used from data ingestion to data consumption with related technologies.

Translate
ask_bill_brooks
Platinum ⭐️
ask_bill_brooks
Platinum ⭐️
August 2, 2022

HI @Christ 

If you'd like more details about data model design and implementing them using Cloudera Data Warehouse over and above the documentation @shehbazk provided links to, I'd recommend you watch the recording of a webinar Cloudera held on the topic quite some time ago, Data Modeling for Hadoop and the subsequent blog post Common Questions on Data Modeling for Big Data.

 

 

Translate
Bill Brooks, Community Moderator Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
shehbazk
Gold ⭐️⭐️
shehbazk
Gold ⭐️⭐️
June 24, 2022

@Christ  Thanks for your feedback on the documentation, I will highlight this to our document team. About your query, we need to open a support ticket because it requires the involvement of our product team.

 

Please let us know if you have any other queries.

 

Thanks,

Translate
shehbazk
Gold ⭐️⭐️
shehbazk
Gold ⭐️⭐️
July 30, 2022

Hi @Christ 

 

Can we mark this as resolved?

Translate
VidyaSargur
Community Manager
VidyaSargur
Community Manager
August 2, 2022

@Christ, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
Terms & ConditionsAccessibility statement