Dataset comparision from Oracle and Teradata

prasson_ibm · Post by **prasson_ibm** » Mon Dec 20, 2010 3:55 am

Hi All,
I have dataset generating using Oracle and Teradata.
One job has source as Oracle and other has source as Teradata.
I need to compare two datasets generating from these two jobs.Is there any way i can compare datasets.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Dec 20, 2010 4:38 am

Difference stage, Compare stage, Change Capture stage?

prasson_ibm · Post by **prasson_ibm** » Mon Dec 20, 2010 5:20 am

Hi Ray,

Thanks for your suggestion,but i have multiple jobs creating these datasets,so i cant prepare a job to compare using difference stage,compare stage or change capture and meteadata for all these jobs are not same.Is there any way i can check the file differce (.ds) on unix/Aix server.

Thanks

wernerg_at · Post by **wernerg_at** » Mon Dec 20, 2010 5:29 am

you may create a dataset dump using the orchadmin command and do a dump-comparison on operating system level using diff or sdiff.

BR

Werner

ray.wurlod · Post by **ray.wurlod** » Mon Dec 20, 2010 3:09 pm

Note that the *.ds files will always differ from each other. Comparing those is pointless. Werner's approach will get you what you seek, or very close to it.

asyed · Post by **asyed** » Mon Dec 20, 2010 9:52 pm

ray.wurlod wrote:Note that the *.ds files will always differ from each other. Comparing those is pointless. Werner's approach will get you what you seek, or very close to it. ...

Hi Ray,

Can we have a job with run time column propagation enabled, with generic toolbox having orchestrate code for changecapture etc.

we can try to pass keys/values as arguments to the orchestrate command in generic toolbox.

Thanks,
Asif

prashanth.spl · Post by **prashanth.spl** » Tue Jan 04, 2011 10:52 am

Asif,

You can use the Compare stage to do the comparison between 2 different source by using RCP. We have done this to compare Oracle and teradata.