DSXchange

Would it not be a good idea if you can have the names of jobs pertaining to a particular subject area written to separate files from the table i.e. subjectAreaA.txt,subjectAreaB.txt with job names passed as comma separated value. You can then read these files by the execute command stage and then pa...

try stopping the job mon and restarting it .

are you being able to view data in the two sequential files ?

i think you need to install the .net framework with it too. worked for me

you dont need to install the server on all machines but the engine should be copied to all nodes as far as i can remeber

There is a utility in the client CD called hashed file calculator (HFC.exe). It is a good one for atleast specifying modulus etc. Usuaully a Type 30 dynamic hashed file is used.

Yes the irritating issue! you need to cater the null handling here yourself,

put something like you can also do the null handling in the column definition of the source. and you can also define it non nullable in the target.

cant do much then

At the Shell
------------

- Execute the following commands:
cd $DSHOME
. dsenv
bin/uvsh

- If the job is locked, execute the following:
UNLOCK RECORD jobname ALL

Then go in the repository and delete the job

Another reason it should not be called Fast load is because Fastload does not support loading into a table with secondary index on it.

Teradata Certified Master V2R5

Thanks, but i do not support the idea that it should be called "Fast load in append mode" in the first place as the name conflicts with the real functionality of fastload itself. Apart from this the only fast load which the job does while using Enterprise Edition is into the empty table wo...

where did i say it can ?

this is what the teradata enterprise stage does internally in the first place..................

it will ignore the values when you use the enterprise stage. this is because the work table which is created is based on the concept create SET TABLE orch_workxxx as select * from source with data and not . a create multiset table work_orchxx as source with data this will drop any default values. Al...

You cannot fastload into an already populated table. it Multi loads data into the table. this is one of the reasons that a temporary table is created when we use the enterprise stage.

Teradata Certified Master V2R5