Archives of the TeradataForum

Message Posted: Fri, 01 Nov 2002 @ 16:54:31 GMT

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

Hi,

I am trying to measure performance of OleLoad(fastload) On teradataDemo version on Windows 2000

We are transfer data from SQL server to teradata on both local and remote machine.....

following are the summary

for remote data Transfer
-----------------------------
     Source (SQL server) is System "A"
     Destination (Teradata) is System "B"
    Oleload Method == FastLad
     Size of SQL source data === 498MB
     No of Rows:                   === 4478720
      Time Taken ==== 13 minutes

OLELOAD Fastload Data Summary for Local Machine

         Source machine( SQL server ) == local
          Destination Machine (Teradata) -- Local
           Size of SQL database : 725MB
         No of rows ------ 6698720
         Time Taken to transfer from
         SQL server to teradata      ---- 22 minutes

In both the cases we have only 77 unique rows..
all remaining rows are duplicate rows.......
in teradata duplicate rows are droped......

My Question is
     is the time showing above is for only for unique
rows(only 77).. or it included duplicate rows also?

or for duplicate rows also...
Total no of rows 6698720 on local datatransfer
and on remoete data transfer rows  : 4478720

Thanx

-madhu

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