Best way to compare contents of two tables in Teradata?

Posted by Cade Roux on Stack Overflow See other posts from Stack Overflow or by Cade Roux
Published on 2010-03-18T17:44:27Z Indexed on 2010/03/18 19:51 UTC
Read the original article Hit count: 508

Filed under:

teradata

|

data-comparison

|

sql

When you need to compare two tables to see what the differences are, are there any tools or shortcuts you use, or do you handcode the SQL to compare the two tables?

Background: In my SQL Server environment, I created a stored procedure which inspects the metadata of the two tables/views, creates a query (as dynamic sql) which joins the two tables on the specified key columns, and compares data in the compare columns, reporting key differences and data differences. The query can either be printed and modified/copied or just excecuted as is. We are not allowed to create stored procedures in our Teradata environment, unfortunately.

© Stack Overflow or respective owner

Related posts about teradata

OBIA on Teradata - Part 2 Teradata DB Utilization for ETL

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Techniques to Monitor Queries and ETL Load CPU and Disk I/OSelect username, processor, sum(cputime), sum(diskio) from dbc.ampusage where processor ='1-0' order by 2,3 descgroup by 1,2;UserName Vproc Sum(CpuTime) Sum(DiskIO)AC00916 … >>> More
Teradata group by time interval

as seen on Stack Overflow - Search for 'Stack Overflow'
Can anyonen help with Teradata? I want to create a query that is a standard select count(*) from Table where Column = Something but has a group by time period done by 5 minute time intervals the time column is in 'Time' format any idea? >>> More
Teradata equivalent of persisted computed column (in SQL Server)

as seen on Stack Overflow - Search for 'Stack Overflow'
We have a few tables with persisted computed columns in SQL Server. Is there an equivalent of this in Teradata? And, if so, what is the syntax and are there any limitations? The particular computed columns I am looking at conform some account numbers by removing leading zeros - an index is also… >>> More
Connecting to Teradata via PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
We need to access a Teradata database via php application We don't have odbc (unixodbc etc) on the server. How might one go about connecting to a teradata database quickly. Keep in mind - this app needs to be as portable as possible. >>> More
My experience working with Teradata SQL Assistant

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/LifeLongTechie/archive/2014/05/28/my-experience-working-with-teradata-sql-assistant.aspx To this date, I still haven't figure out how to "toggle" between my query windows. It seems like unless I click on that "new" button on top, whatever SQL I generate… >>> More

Related posts about data-comparison

EBS Seed Data Comparison Reports Now Available

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Earlier this year we released a reporting tool that reports on the differences in E-Business Suite database objects between one release and another. That's a very useful reference, but EBS defaults are delivered as seed data within the database objects themselves. What about the differences… >>> More
IronPython/C# Float data comparison

as seen on Stack Overflow - Search for 'Stack Overflow'
We have WPF based application using Prism Framework. We have embedded IronPython and using Python Unit Test framework to automate our application GUI testing. It works very well. We have difficulties in comparing two float numbers. Example class MyClass { public object Value { get; set;} … >>> More
Schema compare with MS Data Tools in VS2008

as seen on Stack Overflow - Search for 'Stack Overflow'
When performing a schema compare having db_owner rights on the target database results in the following error: The user does not have permission to perform this action. Using the SQL Server Profiler I figured out this error occurs executing a query targeting the master db view: [sys].[dm_database_encryption_keys] While… >>> More
Best way to compare contents of two tables in Teradata?

as seen on Stack Overflow - Search for 'Stack Overflow'
When you need to compare two tables to see what the differences are, are there any tools or shortcuts you use, or do you handcode the SQL to compare the two tables? Background: In my SQL Server environment, I created a stored procedure which inspects the metadata of the two tables/views, creates… >>> More
Answers to Your Common Oracle Database Lifecycle Management Questions

as seen on Oracle Blogs - Search for 'Oracle Blogs'
We recently ran a live webcast on Strategies for Managing Oracle Database's Lifecycle. There were tons of questions from our audience that we simply could not get to during the hour long presentation. Below are some of those questions along with their answers. Enjoy! Question:… >>> More