Re: DATA P0PULAT1ON
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: shastry17@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Dec 2007 17:20:05 -0800
Data population means bringing data from production to QC / UAT /
Development environments. Make sure you scramble sensitive data
like SSN , DOB, Routing# , Salary etc as the case may be ; The
difficulty lies in scrambling RELATED data (eg) SSN in table A of
Employee is present in Table W, Table G; Therefore when you
scramble SSN to a different value the same scrambled value needs
to go to Table W and Table G for that particular employee.
Depends on the Constraints in the schema. VPD/FGAC may not be of
much use since it blanks out the values; Hence scrambling.
Methodology might vary depending on the need.
HTH
GovindanK
On Tue, 11 Dec 2007 03:06:47 +0530, "Anant (DBA)" <shastry17@xxxxxxxxx> s
aid:
Hi all,
Can any please suggest me what is data population in Oracle
database?
User has requested , Data population from Prod to dev
instance.
Does this mean a data refresh of tables from prod to dev?
Thanks,
Ann
Other related posts:
