Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2014
    Posts
    2

    Question Unanswered: DB2 - Transformation Data (not real data - relationship)

    Hi,

    I am using DB2 on Mainframe Production, and I would like to provide to developer team the "same" database structure on Test Environment, however, the company does not allow to load on test environment, data from production (real data), so I would like to know if someone knows any tools (could be an ETL) that allows me to load the data to the test environment but changing/transforming/mixing up the data (including the relationship if there is) for some information such as: ID, phone, address, or something that it is possible to set up.

    thanks.

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    All of the major tool companies(BMC, CA, IBM, ETC...) have this type of tool. They all get the job done. Or if that type data only exists in very limited tables as should have been designed do it yourself.
    Dave

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Adding to what dav1mo said, google "test data management".
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •