Archives of the TeradataForum

Message Posted: Fri, 14 Oct 2011 @ 09:05:51 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Testing the data on two different servers

From:		Kenneth Hansen

Sravan Kumar Bodla wrote:

Using Queries, can you please help me how can we make sure the data loaded on new server and old server is same {Same file and same job is used to load on both the servers, loads are done using DATASTAGE}?

Sorry for the late response.

Two answers:

There are lots of reporting tools that will source data from multiple sources and combine them in a single report. So you could run the same query against the two locations and prove they produce the same report Or use the reporting tool to report the differences, if any.

2) In practice no-one compares large tables on two sources record by record or record column by record column. Those that need to be satisfied should specify their test criteria well in advance.

e.g. Number of rows, min, max, mean values on specific columns, perhaps per date range, etc.

Run this on the first server before migration. Then run on the second and compare, possibly using the merge facility of your BI reporting toolset, or just on Excel!

I would be interested to know how it actually goes/went.

Kenneth Hansen
Independent DW Consultant
Certified Teradata Master


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference