Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 20:50:18 GMT


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


Subj:   Re: Loading Fact data directly onto Teradata
 
From:   Kohut, Eric J

Jose,

I'm assuming that IsNumber() is a serial id.

This will be available in V2 R5 in some form. Not sure if it will be exactly what you are seeking.

In the current version you can do this for most application requirements ,except to differentiate or annotate multiple duplicate input rows with a unique id, today by simply running a select with a CSUM(1, ) as an additional column from an existing table.

I realize that this isn't as easy as you might like but getting a serial number creation to run in parallel is not as easy as a serial number on the other systems. The other RDBMS IsNumber() functions are all limited to running on one CPU and thus are limited in their scalability.

I'm not sure about IsDate(). I'm assuming that this is simply today's date at whatever point you are running. Does this function on other platforms know to differentiate between when a process started and when it is running to keep the date consistent during a process that may span midnight?

We do have the ability to simply select date for very simple uses of this. Also if you select it into a single row table and then product join this to any row you need the date on you can keep it consistent across the mid-night span.

Finally, as far as row level transformations, Case Statement will handle the majority of simple to moderate and sometimes complex transformations.

If you are doing very complex transformations that utilize the internal functions of the tool you are using, then these may or may not be able to be easily replicated in SQL.


God Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020