DSXchange

Hi Aparna,

Did you add all the parameters in your job and set the values for the parameters correctly? Just check it! It may be a source for your problem and it is always least noticed.

Hi Suma, You can very well arithmetic functions as a type conversion will be done implicitly. The function Num(STRING) will return success if the string supplied can be converted to a number. This can be used for validating the string. I don't know if there is a function with name 'int' is there. :r...

Hi Rimna, The purpose of the column generator is very much evident from it's name, generation of a new column. It has a wide range of use. One of it's key uses is the generation of dummy column. You can do a search in this forum to know more about the column generator stage. You cannot really pin-po...

Hi

Just override the default value for the $APT_CONFIG_FILE parameter with any of the existing config file name and path. The problem will be solved.

Hi Write a post-job DataStage basic subroutine that counts the number of records from the source link and the database write link. Then match the counts and if they do not match conclude that there is some error. I don't think reject capture will help you in this regard because the records are not a...

Lot of discussions happened in this topic. Just do a search on changing parameter values during run time. You will get lot of information on this topic from this forum.

Regards,
Vignesh.

But Ray, doing with simple unix commands will simplify the job to a great extent. Using the stream editors like sed will simplify the preparation of the sequential file without having to go for a job. If you are calling DSJobReport from the After-Job subroutine, you can very well use DataStage Basic...

You can do everything right from writing to a sequential file or loading directly into an audit table (in which case, you need licensed ODBC driver for the database). Writing into a sequential file is very simple and you can browse through the DataStage Basic manual to have a very better picture. Re...

Hi My job is like this. Source1 DB2->Sorter1->A A->Sorter3->Transformer->Target DB2 Source2 DB2->Sorter2->A I have sorted the records from both source DB2 plug-ins based on a key key1 before joining. Again after join operation, I am sorting the records based on the same key key1. My query here is do...

You can make use of DSJobReport routine to capture the audit information about a job and it can be called from after-job subroutine.

Regards,
Vignesh.

67 lookups in a single job ?? That sounds problematic...You break your job to simpler sub-jobs using filesets and datasets and that is what they are meant for.. Instead of one complex job, break it into a few simpler jobs and infact, this would yield better performance to you.

Vignesh.

Hi My job runs perfectly well with a smaller volumes in the order of 2 or 3 millions. But once when the volume shoots up, my job throws the following warning continuously but job runs to completion without aborting. APT_ParallelSortMergeOperator,2: Unbalanced input from partition 2: 10000 records bu...

Thanks for the info rajeev !!

As its name suggests, lookups are used for looking up some values based on key values. Generally dimension tables are looked up. Volume of data lookups can handle depends on your hardware configuration of the server. Generally tables or files that do not grow enormously over a period of time are loo...

Thanks Bland !! I too got to know how to parameterise the derivations. Sorry Vivek, I gave you a wrong information.

Vignesh.