DSXchange

In the Teradata Mload/Input/Limit Settings Tab you can specify number of concurrent sessions and time of "TABLEWAIT"

I may have the answer but I was hoping for a confirm that I am correct from one of the DS experts ie Ray, Craig, Ken

Since I am speaking of a diff of over 600 rows a second with this amount of data we could be speaking of over 2 days diff to source this data

seems to make a large speed diff 220m source rows coming from hashed file to 2 hashed files based on source_cd

Is there any speed difference in using a stage variable of If not(lnkLkUpBranch.NOTFOUND) and lnkLkUpBranch.Source_System_Id = 15 Then @TRUE Else @FALSE or setting as a constraint on a write to a hashed file of -- not(lnkLkUpBranch.NOTFOUND) and lnkLkUpBranch.Source_System_Id = 15 ????

Be aware that writing to a file with a duplicate keyed record will over write the existing record

Have changed code to a before/after subroutine and now move ans to @user0 but how can I reference this (@user0) in a transformer stage later in the job?? It returns clean but I always have 0 when I try to use the env variable. Can this be done??

I have written a routine with one argument which returns a single value answer. I need help in how to use this as a before-job subroutine and how to retreive the answer for use within the job. The code for the routine (which is currently saved as a transform) follows -- OPEN 'company' to COMPANY_FIL...

Output format is YYYY-MM-DD 00:00:00 for Oracle dates. The way you have the date listed I would do an Iconv on the Input and Oconv to Oracle Format

Arnd

While I know you can read and write it in the same job I am seeing jobs for the first time creating a file and trying to use it at the same time and was wondering if this is correct.

Can a hash file be created and used in the same jobstream ie create hash file from oracle 9i and lookup in transform of teradata?