DSXchange

What are you exactly looking after?
If you were not able to open the proerties of the JobActivity of Routine activity in JobSequence, you need to check your version of Serverpack installaion and/or a patch avaialble as dsclient_xp2.

Try passing the exact length of the decimal field like "000000.0000" to NullToValue expression. Additionally, try disable the CombinableOperator in your transformer property to get more diagnostic message.

If the source is fixed widht, ideally it should me at the max number of readers that you can include. Which is limited by your config file. Practically there are several other factors that might come into picture, like Netwrok traffic for each node to the Disk.

Are lookin at the version of Datastage or the size of the server? Assuming you are after the server size and capacity, the vauge answer would be, "it depends on your jobs desing that you use". That true. More the stage, more the resource used in Datastage. I have seen some site, where, ETL is used j...

Was your uvodbc.config for your new project been updated? Is the both the project on the same server?

Are you resetting the job after Abort. Does it shows any log that StoredProcedure been exeduted after the entry of Job reset?

Hi Nagesh,

May I know in what case you use RPC for Shared Container function. Do you change metadata dynamically?

What is the input format? 1900yy Is your input has only 2 digit of Year patetrn. Does your job abort now? What is your source? If it is database, why can't you convert it during extract?

Is it a Multiple instance job, reading all the files. What the problem you are expecting? If it is related to the layout mismatch and if you are sure that the number of records that turns out odd will be in manageble number, its better to give out as warning. Else there may be a case where it might ...

Hi Roma, Welcome Aboard!!!:D Hope this is not a Inteview question in Target that is been asked. Datastage uses the Orchestrate framwork. The core Engine of Datastage Px is Orchestrate. Datastage just wraps these operator in the stages and give you plesent GUI. Refer Orchestrate Operators Guide for f...

You can reset the job, either by JobSequence or thorough routine. It depend on the way you call the job.
But what is the situaion you want to do this?

Is it for the same table without any chage in query or any parameter, it shows you the data at times without any error?

What is the format of the timestamp in input?

Designer doesn't show you any result. At max, will just show you the Statistics. Check if you are converting any date field to char.

Try passing the format like %yyyy-%mm-%dd %hh:%nn:%ss.