Some general Oracle data warehouse questions
- - 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?
0