DSXchange

The full outer join will combine table contents, never drop rows. See http://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join for a good description of the join functionality.

use your favorite PC compression program to unpack the .isx file - you will be surprised at the result.

Do users 1, 2 and 3 read different target tables? Or do you just have one target table but 3 different query requirements?

Although I'm unclear about the cause of the problem, what happens if you set the character set to "UTF-8" in the job?

Let us simplify the problem and take the output out of the equation. Create a simple job with a row generator going to your surrogate key generator and then outputting the generated key to a PEEK stage. Does this test job work? Does your sequence (as defined in "source name") exist in the ...

Taral,

that means you didn't look hard enough for it; it is part of the product and should be present.

Technically that would work, as each machine only has one 8.x instance and now the itag can be specified as a non-default one.

Start with a simple job that takes your sequential file and reads it using the file's NLS set of GB_2312-80 (assuming that is the file's setting), then write to another sequential file in unicode format and look at the file in Unicode to see if the contents are correctly mapped. Once you have that w...

I think you are going in the right direction, but you should tell us the logic of how you link the files to the tables, i.e. are you using the number of files to determine which table to load, or perhaps the name of the file to determine which table to load? Are the file formats the same for all fil...

Take this problem in small steps. First you need to load your file into a hashed file or a database table. In order to do that, you need to create a DDL or schema of what that table should look like. Is it correct to assume that a table/file in the form of: Name Type FROM VarChar ACCUNT VarChar TO V...

If the files are not visible from the OS then DataStage cannot access them either. The standard tools of NFS mounting, rcp, scp, or ftp will allow DataStage to process the files.

Step by step.

What is your source and what stage are you using to read it? Don't use "view data" to determine whether or not data is being correctly transferred.

Even though I don't have Teradata here, the enterprise stage is present and as you noted the attributes cannot be changed. But I did call up the Connectivity Guide for Teradata Database and it states that the enterprise stage doesn't support timestamps (or that Teradata doesn't support that data typ...

I just re-read the initial post and saw "max aggregate" and now I wonder if the SQL in the query might be causing problems. Can you post the SQL or write a test job to change it around to see if that changes your error or makes it go away?

Same here, but I've filed the symptom and fix away for future use.