Compare heterogeneous database

[bala0786]

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

[Adara]

A Heterogeneous Database System is an automated (or semi-automated) system for the integration of heterogeneous, disparate database management systems to present a user with a single, unified query interface. Heterogeneous database systems (HDBS) are computational models and software implementations that provide heterogeneous database integration.

[stevebucknor1]

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. This is really amazing and outstanding.