DSXchange

Hi, We have to truncate around 30 tables before loading them individually in differnt DataStage load jobs. So, wondering which one is the best among the below options in terms of faster truncation and loading (time together). 1. Write a stored procedure to truncate all the tables before we trigger t...

There could be more than 10 databases/applications and each would consist around 20 to 30 tables. Can the .dsx file do any wonders here? I mean using Unix scripts to pass the table names/keys etc.. to the .dsx of a precreated datastage job and then import it back. This is just a thought and not sure...

Hello all, Prior to posting a question here, I searched the entire repository to find a solution to my question but no luck!! (may be my poor searching skills :oops: ) Question: We are trying to build a framework where a single job has to be build which should pick up the fields from the table dynam...

Hello, We have a requirement to load the dataset into a text file, archive the text file and delete the datasets due to the space constraints. We thought of loading the data from dataset to a text file through orchadmin utilities. So, can anyone suggest if this is a good approach to use the orchadmi...

May be, a shell script can do the job to remove the new line characters before the double quotes in the file. Then, this script can be called in the before job subroutine and have the cleaned file ready for the job as a input.

'0':<InputColumn>

But, need to take care of the total length and the datatype of the output column to which you are going to map this.

Hi,

I had a similar question and while searching through the forums found this post. I am just eager to know if DataStage 8.1 is supported on Windows 2008 server OS. Most of the sites says that it is not compatible with Windows 2008 server. Can someone please confirm?

Or, if your jobs are scheduled on any scheduler like Autosys, Control-M; you can take help of its run status...

Check the value from the source and then we shall go from there...

Mayura,

Check if the number of input columns and the field names in the source file/db is matching with the number of fields defined in your datastage job.

Since, the source is a varchar field, wondering if you are geting any spaces or empty from it!!

If so, you might get this error. Check this way -

If Trim(NullToValue(out.AMOUNT,'0')) = '0' then 0
Else
StringToDecimal((TrimLeadingTrailing(out.AMOUNT)))

Please let us know the results.

As Kryt0n said, your partitioning on the input links of the change capture stage might be wrong.
Try to hash partition on the key cloumns on both the input links and see..

Let us know the result.

Hi, I came across a scenario while doing the delta between previous data and current data. In previous data, i just have one record and in my current data, i have an updated record and a copy of the record which is already there is previous data. When, i do a delta, i should get only one update. But...

Thanks Craig!

Thats what i was also thinking to do, but wanted to make sure.

Hi, We are in a process of exporting our jobs in production. Our project is a shared one and we just want to export only our jobs into a single .dsx file. I have searched some old posts and many gurus suggested to use some scripts. So, i just wanted you to confirm below 2 questions. :roll: 1. We can...