Friends,
I'm working in Data Masking Company. Now I'm developing Teradata Scramble.
I've a situation here to scramble a table having more than 10 Lakhs to 10 Cores of records, but due to some performance issues I'm planing to split the records into many phases depends on total records and do the scramble for each and every phase.

I have composed a Teradata (V 14.10.3.09) query with help from the forum and modified it a bit to get count(*) of past six weeks, for present hour and same day of week.
For eaxample if current_timestamp is 2015-08-25 08:21:43.210000+00:00

Hi Experts,
 
We are using HASH_MD5 function to calculate the checksum of columns in a table by concatinating them. hash_md5(col1||col2||col3||.......||col32). This function returns distinct value till certain column limit but any further column addition does not have any impact on checksum calculation. 

hi I have a  TABLE1  with this structure 

CREATE  MULTISET TABLE DB1 .TABLE1 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      PRODUCT_NBR INTEGER

)

Hi,
Can someone with query to find size of selected rows in columns from teradata table. For ex
A   B   C    D   E
1   1    1   1    1
2   2    2   2    2
1   3    1    1   1
1   4    1     1   1
Need size for A + B for where A = 1
 
Thanks in Advance
 

I have 2-3 different column names that I want to look up in the entire DB and list out all tables which have those columns. Any easy query?