DSXchange

Yes. Where you want the data to go is the path you'll need to put into the resource disk path of the nodes of the Config File. You've got a 2 node SMP currently writing to the same place on both nodes. Assuming there is no contention when writing to the same actual physical disk, this shouldn't be a...

The Data File Path in the config file? That is not correct. You need to point to the descriptor file. It is this file which will contain the config file paths to the resource disks for the dataset. The descriptor file will provide orchadmin ont he command line or the Dataset Management tool in Desig...

Maybe I'm mis-reading the requirement. I've not done MQ in a while. Why not define a job and have it constantly run waiting for a message from the queue? As soon as a message arrives, it will be delivered to the job and processed. When you want to stop the job, schedule another DataStage job to inse...

They are the memory mapped files used when the lookup data in a job runs out of physical memory and starts getting swapped to virtual memory. The directory is configurable via the config file for the scratchdisk resource defined there. Currently it appears to be /tmp or is missing altogether and the...

Using a shell script is not a good plan. there is no need.
Use the MQ Stage. Why use a shell script? Did you need this to be realtime? No problem. Read the documentation.

If your files are not fixed width, then do a search on this APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL.
The solution will be to do two things.
1. Add that env variable to your Project and set it to True
2. Define the default for any field that contains a NULL to "" (empty) at the line level.

DATE!!! But no data pull is correct. It is as if DatgaStage converts it to an internal number but is using the wrong date format mask in doing so, therefore the OCONV back is not the correct date.

Teradata API Stage - DLL teradata.so, Version 1.2.4. DATE fields are ANSIDATE FORMAT yyyy-mm-dd. We routinely change the Table definition metadata of any DATE field to CHAR(10) because this appears to be the only way to handle a date field via the Teradata API stage. Can be this true or are we missi...

Could you explain what function against the data is being performed in the XSLT that cannot be done in the Transformer against parsed XML fields? I'm curious.

I may be mis-reading this post but it seems like you have written an Excel macro to create a .dsx file for your table definitions. You are then asking why these .dsx s do not import into DataStage. If this is correct then the answer is easy; Your reverse engineering (hack) of the DataStage export/im...

Compare the Starting Job... director log entries in the QA and Prod environment job runs to verify that the two parms are identically defined and populated to the job in both QA and Prod.

Each Job name must be unique within the Project, not category. I think I read that you can't name it ROOT either.

There is a kind of a neato hack that would work but it would involve some heavy derivation lifting and most likely is NOT worth it. Replace the Sequential File stage with a Folder stage with a column for the file name. This would create a "late binding" effect in that the file would not be...

What is the XPath for the Period repetition key?

You could build a DataStage job to query the Oracle system tables for the source table. When a change is detected the job would create the proper schema files. Another DataStage job, RCP enabled, would read the source Oracle table and write out the fields to the just generated schema file in a Seque...