Oracle Autonomous Data Warehouse Questions

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 18 2022

Hi,

We all know it's really hard to get good pricing and cost information.

Please share what you can so you can help your peers.

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 18 2022

Please share with the community what you think needs improvement with Oracle Autonomous Data Warehouse.

What are its weaknesses? What would you like to see changed in a future version?

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 18 2022

Hi Everyone,

What do you like most about Oracle Autonomous Data Warehouse?

Thanks for sharing your thoughts with the community!

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 18 2022

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
Jul 18 2022

If you were talking to someone whose organization is considering Oracle Autonomous Data Warehouse, what would you say?

How would you rate it and why? Any other tips or advice?

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)

Hi Everyone,

What do you like most about Oracle Autonomous Data Warehouse?

Thanks for sharing your thoughts with the community!

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)

Hi,

We all know it's really hard to get good pricing and cost information.

Please share what you can so you can help your peers.

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)

Please share with the community what you think needs improvement with Oracle Autonomous Data Warehouse.

What are its weaknesses? What would you like to see changed in a future version?

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees

If you were talking to someone whose organization is considering Oracle Autonomous Data Warehouse, what would you say?

How would you rate it and why? Any other tips or advice?

Cloud Data Warehouse Questions
Netanya Carmi - PeerSpot reviewer
Netanya Carmi
Content Manager
PeerSpot (formerly IT Central Station)
Netanya Carmi - PeerSpot reviewer
Netanya Carmi
Content Manager
PeerSpot (formerly IT Central Station)
Nov 07 2022

Why would this be a good choice for my company?

Evgeny Belenky - PeerSpot reviewer
Evgeny Belenky
PeerSpot (formerly IT Central Station)
Sep 09 2022

What are the relations between them? What are their use cases?

Richard Winter - PeerSpot reviewer
Richard WinterMany of the comparisons of data lake and data warehouse that you see (such as… more »
Wallace Hugh - PeerSpot reviewer
Wallace HughI assume the "Data Warehouse" term here is in the traditional/conventional… more »
Djalma Gomes, Pmp, Mba - PeerSpot reviewer
Djalma Gomes, Pmp, MbaThose are just terms used by marketing. 30 years ago, BI required a… more »
7 Answers
Ariful Mondal - PeerSpot reviewer
Ariful Mondal
Consulting Practice Partner - Data, Analytics & AI at FH
Hi,  It seems that Snowflake is becoming very popular nowadays. I have done some training and live sessions by Snowflake.  I would like to hear your opinion about the main key parameters we should look for when choosing Snowflake over other cloud-based data lakes, such as costs, ease of use, ma...
Read More »
Steve Sarsfield - PeerSpot reviewer
Steve SarsfieldI wrote a white paper on this that you can download here:https://bit.ly/3bRTCqp… more »
MarkSmith - PeerSpot reviewer
MarkSmithWe did a PoC with Snowflake.  scale up and down works as advertised.  Be careful… more »
Jay Allen - PeerSpot reviewer
Jay AllenSnowflake is a columnar stored database. It is not a “data lake.”
6 Answers
RajneeshShukla - PeerSpot reviewer
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
I have seen bitmap index as the preferred choice in a Data Warehousing environment. I wanted to know reasons for that. As per my own experience, one reason is bitmap indexes are compressed and hence confined in less index space. When we have large number of FK indexes then this index space matter...
Read More »
Gouri Mishra - PeerSpot reviewer
Gouri MishraBitmap indexes are useful for low cardinality column(s) for 3 primary reasons… more »
1 Answer
RajneeshShukla - PeerSpot reviewer
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
I am a solution architect for a global tech vendor. I am looking for any general guidelines to allocate tablespace quota to different layers/schemas in the ETL flow of a data warehouse (% of total space in each layer). I have these 4 layers: Staging -truncate and load data from source files ...
Read More »
Gouri Mishra - PeerSpot reviewer
Gouri MishraSpace requirement will be directly dependent on design considerations and data… more »
2 Answers
RajneeshShukla - PeerSpot reviewer
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
Hi community, I am a solution architect for a global tech company with over ten years of experience. What are the benefits of having separate layers or a dedicated schema for each layer in ETL?  One dedicated layer for staging, one for type 1 persistent tables, and a dedicated schema/layer for...
Read More »
Gouri Mishra - PeerSpot reviewer
Gouri MishraHere are some of the advantages of managing data in different layers: 1.… more »
reviewer1389651 - PeerSpot reviewer
reviewer1389651I have over 15 years of ETL experience on "real world" projects & am now… more »
Data Sleek - PeerSpot reviewer
Data SleekTraditional ETL would usually use a dedicated database (or even database server)… more »
6 Answers
it_user698982 - PeerSpot reviewer
User

Which ETL or Data Integration tool goes the best with Amazon Redshift? Ex: Matillion, Informatica Cloud, Alooma, SnapLogic, SSIS 

Ariel Lindenfeld - PeerSpot reviewer
Ariel Lindenfeld
Sr. Director of Community
PeerSpot