DSXchange

You posted two issues: 1. View Data is disabled because this is a pseudo-Active stage, meaning it "does" something. It can't show you the results because the data has to be generated first, hence the "Active" name. It would be nice if the View Data could view each underlying file, but viewing the re...

I don't know if there's a difference in Teradata plugins for different versions of Teradata client. That being the case, there's nothing you should have to do on the DataStage side. What you do need to do is make sure that all appropriate dsenv changes are up to date for the new client, such as path...

What's the "problem"? Since we don't have the error message we really can't tell you the issue. Have you grep'd the file into another and tried viewing in the grep'd copy to verify it's not a metadata issue? Do you have embedded quotes that wrap <CR>/<LF> or delimiters that needs honoring, thus grep...

I took the time to review every post made by the questioner. Some of the questions were answered within minutes of posting. Others were answered in a lively discussion from multiple sources giving different opinions. Only one question went unanswered, which dealt with Viewing Data using the Merge st...

Projects don't connect to a database, jobs connect. In one job, you could have different OCI stages talking to different instances, all within the same job. The only requirement is that all Oracle stages must use the same Oracle client installation, which is configured in the dsenv file and applies ...

Use OCI stages, which use the SQLnet Oracle client. Make sure the DBA's install the client on the Unix server, put ORACLE_HOME and the shared library paths in the dsenv file, recycle DS services, and you're all set. DS resolves thru $ORACLE_HOME/network/admin/tnsnames.ora file for all connections, s...

Using Director: on the Run window that blank white box that says Invocation ID, put some text in there and see what happens. Using Batch Job Control: attach to the job using Jobname.InvocationID where just like using the Director, supply some text and see what happens. Using Sequencer: use Jobname.I...

During transformation, reference the target to determine if the natural key has been assigned a surrogate key. If not, then assign a surrogate and treat as an insert. If the surrogate key is found, then use that and treat as an update.

Can't remember either, but there's always the array as an argument trick.

Why are the 10000 rejecting? Primary key violation with INSERT ONLY SQL? You already know the answer. Don't try to INSERT rows that are already there, or switch your SQL to INSERT or UPDATE and superfluously update them (potentially). Or, build a more intelligent job that references the target and u...

No.

A SQL query, using CASE or DECODE statements to logically move information to the appropriate column, using GROUP BY yourkey style logic with MAX() derivations on all CASE derived columns will give you a vertical pivot. EX: select key, max(val_1), max(val_2), max(val_3) from ...

Make sure all jobs that are in the Sequencer are compiled.

Yeah but how wide are your rows? If the problem started today, then it means today there's no large amount of rollback space available. There's no way to get around using rollback unless you switch to other methods that bypass transactional processing, such as sqlldr with DIRECT path, but you'll sti...

Use a Batch style job to compute the values you need, and then have the Batch job run the Sequencer giving it the values as job parameters. Since the two dates depend on three arguments, you need some chance to compute the dates. Passing those to the Sequencer as job parameters mean that they're ava...