Database DataWarehousing (MOSC)

MOSC Banner

Some general Oracle data warehouse questions

edited Jun 2, 2016 5:11AM in Database DataWarehousing (MOSC) 2 commentsAnswered
  • - What do people typically use for data masking, i.e. my production database upstream has a table with a column of SSNs. I want to mask that in the downstream databases with XX-XXX-XXXX? Can Golden Gate, Streams, OWB or ODI do this? Does this functionality come natively with Oracle like via a PL/SQL package, etc?
  • - What is the difference between Oracle Advanced Analytics (which is the R programming language and Oracle data mining) and OLAP? I would imagine that Oracle Advanced Analytics is for people who don’t need a full out data warehouse with OLAP, etc. It also looks like a solution where you don’t have an ETL or ELT process between databases, it’s where you just analyze the data right there in the OLTP database but not a full data warehouse solution?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center