DSXchange

Tell us how you've configured the target Teradata Connector.

What is the source? If it's a Data Set and there's no repartitioning, it should be very fast. On the other hand if it's a database view that's based on a correlated subquery with joins to huge tables, then it's going to be very slow.

Information Services Director is one of the components of IBM InfoSphere Inforamtion Server (just like DataStage and Information Analyzer are components). The function of Information Services Director is to provide the environment in which jobs can be exposed as services that can be invoked by web c...

In a Routine activity invoked from a sequence (which might include a Wait For File activity) you can use the OpenSeq statement to open the file (without reading it), then the STATUS statement can return the file's size and lots of other information about the file. Once you have that, simply close th...

Don't "believe". Check. Test.

The other output contains data for the fact table. Yes, it's mandatory.

Not using the Trim() function - it can only specify one character to trim. However, you can use the Convert() function with a second argument of "". Or you could use nested Trim() functions if there are few characters to be trimmed or you need to trim only from one end, etc.

Replace the target stage temporarily with a Peek stage to isolate where the slowness may be.

Lookup stage seems reasonable, if the smaller Data Set is the reference data and its rows are not exceedingly wide. That is, the reference Data Set can be loaded into memory. Replace the target stage with a Peek stage temporarily, to isolate which part of the job (lookup or Teradata) is the slow part.

Using a BASIC Transformer stage use the derivation expression

Try a Search of DSXchange for "deadlock". Others HAVE experienced deadlocks in databases.

"<none>" indicates that there is no description for the field, whether imported from the database or added manually during the import process or subsequently. "searchable" indicates whether or not the column in the database is indexed. This is determined at the time that the tabl...

The DataStage RPC daemon failed to start.

I don't believe so. You could, however, query the DS_JOBOBJECTS table, restricting the OLETYPE to the appropriate link type (for example CCustomOutput). Location of the actual SQL within the DS_JOBOBJECTS record will depend on whether it's generated or user-defined SQL and, indeed, on which Oracle s...

Yes, you're missing quotes. Please try to diagnose it yourself (anxious to help you to learn, here).

We'll help if you really truly can't solve it.