DSXchange

Search here or UniVerse manuals for COMO and DIVERT.OUT commands. COMO ON derivations.txt SELECT .... ; Your output will be in ./\&COMO\&/derivations.txt Or use SETPTR command mode 3 to direct output to a hold file when the LPTR keyword is used. SETPTR 1,132,20000,0,0,3,BANNER derivations.tx...

Expand stage.

The output pin from a Transformer stage has an OLETYPE of CTrxOutput in its DS_JOBOBJECTS record. Within this record, multivalued field numbers 14-34 describe the columns on the link and, specifically, the derivation expressions are in field number 25. To see just this, try something like SELECT EVA...

If there is no way to identify the delta at source then you will be obliged to fetch all the data from source every time and compare against target.

When's the interview?

... except, of course, for the incorrect concatenation operator.

priyadarshikunal wrote:And what is this 3 GB limit for sequential file stage?

Probably a limit on file size in 32-bit Windows operating system.

Have you (pkll) investigated the Expand stage?

Start by ceasing to believe that rows/second is in any way meaningful. It includes all wait time (while the stages are starting up), it is rounded to the nearest sampling interval, and unless row sizes are identical you're not comparing apples with apples anyway. What's so magic about the 10000 figu...

Technically your expert might be able to argue as follows; a file unit is opened on each resource disk before any actual write occurs, so that the file units are "writing" in parallel.

That's my understanding, in 32K blocks. But the round robin should be happening so quickly that they appear to be writing in parallel.

UNIX permissions. All of the files in the project should, if best practice is followed, be owned by dsadm with group (let's say) dstage. The dsstage user should have the dstage group as primary group. ALL DataStage users should have umask set to 002, so that other members of the group have access to...

In a phrase, "multiple nodes". Which is what I'm sure your expert was referring to. Consider the following configuration file. { node "node01" { fastname "L8BACK" pools "" resource disk "/isdataset0/myProjectName/datasets" {pools ""} resour...

Well, sequential in some sense, although DataStage parallel engine simply doesn't move data in chunks of less than 32KB. So what you're seeing is Round Robin allocation over the directories marked as resource disk for your node. This is the only way that DataStage does it when there are multiple res...

Are the Engine credentials set up correctly for dsstage?

Has user dsstage been allocated to a project role in the Administrator client (for example DataStage and QualityStage Developer)?

Try setting the Data Element in the Columns grid to "Date".