Depends a lot on your situation, the three options are valid.
If you can join and aggregate in Oracle is the most efficient if you just need that, as long as the DB has spare capacity for it.
If you have some Zero-ETL to move the tables into Redshift, that avoids adding a tool and then you can do it there.
And if you already have an ETL like Glue or need it for something else, then you could do it there and avoid pushing the workload the Redshift
- Accepted Answerasked a month ago
- AWS OFFICIALUpdated 22 days ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago
- How can I track third-party software or applications on my EC2 instances or WorkSpaces using License Manager?AWS OFFICIALUpdated 10 months ago
- Amazon GameLift launches support for third-party Infrastructure as Code tools like Terraform and PulumiEXPERTpublished 3 months ago