Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Wink Unanswered: Compare heterogeneous database

    Hi ,

    I would require someone to help me in providing the solutiion for the given scenarios using a query and NOT..without any tool.

    1.Compare Source and Target table in 2 different servers ,source being Oracle DB and Target is DB2 DB.

    2.Compare Source and target tables in same server,source being Oracle DB and target is flat file

    3.Compare Source and target tables in same server,both source and target are flat files

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Define "compare".
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >using a query and NOT..without any tool.
    I need to use a tool to launch query.

    Exactly what constitutes a match when comparison is made?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Mar 2010
    Posts
    2

    Wink

    Objective is to compare the tables which has been exported from Oracle DB to DB2 DB (it may be flat file or any other non-Oracle DB also).

    Once table has been moved ,we need to check for the data integrity as whether the data is same in source and target tables.

    Note:If the database is same I used MINUS query to find which records there was mismatch,but if the database is different for source and target ,I am not sure how to do comparison as the data stored in both tables will not be in same format.say in Oracle DB data will be stored across columns but in flat file / DB2 data will be stored in some other format.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    For flat files you can use the external table feature; for non-Oracle databases - Oracle Transparent Gateway.
    ---
    "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
  •