DSXchange

Job #1: OCI (target table) --> Transformer --> HASH file Job #2: FTP (source data) --> Transformer --> SEQ file Job #3: SEQ file --> Transformer w/reference to HASH file, constraint only allows output rows where unique identifier in source not in HASH reference --> SEQ file Job #4: SEQ file --> Tran...

Perform a lookup against a hash file that contains the target table primary key columns spooled from the table. Use a constraint to only insert rows not in the hash lookup. That will run a heck of a lot faster than using database exception processing to let know the row is already there.

Do you mean update multiple target rows with values derived from one input row? Your question is poorly worded.

In SQL, you'd use a wildcard query. Your question, however, doesn't hint at which methods you prefer.

What do you mean by "copy"?

From the Unix prompt, type in "man rsh" and read it in detail. You can always use Google.

Use a stage variable to track the "key" values that identify a group, and another stage variable to hold the last value seen. Use the appropriate logic to manage the output rows.

Try user-defined SQL

The status values are what the job was given at start time. If the controlling process did not set the values, then you will see that the defaults are used. When you look in the job log, if the log messages contain different values than the status view shows, then the values must be getting manipula...

That topic is widely discussed on this forum. You could try the Search facility.

The user tights on the server were not properly configured. I hate improperly configured tights. They pinch me in the wrong places. Your situation highlights the seriousness of proper metadata, even though Server is highly flexible it requires a high degree of discipline. There's too many implement...

You mean the Command stage? The parameters in the design are using their default values at runtime, rather than those passed via job control? You need to go to Director and double-click on the job from the Status view (the main jobs view). This will show you the parameters and values used when the j...

How are they closing Designer? If they're exiting using standard Windoze methods, the internal lock should release the job. Try exiting the Designer client completely and see if that works. Any chance they're just minimizing a job? Also, make sure that they're not using anything like Task Manager to...

One would expect. For enlightenment, you could always, from an engine command prompt, type in SORT.ITEM DSINCLUDE. You should also be able to view the underlying information in the project/dsinclude folder. Or from DS Administrator in any project use the command prompt and type SORT.ITEM DSINCLUDE. ...

You're missing a subroutine, TIMLogErrorMsg. Find it and compile it.

How about reading this topic m which is actively being discussed right now. In your transformer, you could mass-apply a function to existing derivations. Check it out in the Transformer stage help. Write a NVL type function in DS Manager that can be used to replace NULLs with a passed value. Not to ...