DSXchange

Hi trm, There is no other parameters/variables that you have to set for this. If this variable is set and - 1. File pattern option set in your source sequential file stage to read the multiple source files 2. The File name column option chosen in the Source sequential file stage and the additional c...

Hi, There is an Environment Variable - APT_IMPORT_PATTERN_USES_FILESET, which when set to TRUE, returns the exact file name from which the record is being read. There was a post regarding this in the Developer net forum, which was answered by Danny Owen. I have used this in one scenario, and it does...

Bala, If you are mapping only a certain columns from the transformer to the Dataset, then you would need to switch off RCP on this link. If RCP is ON then, the metadata for the dataset created would consist of all 25 columns (as they are propagated to the next stage), even if only 10 columns are map...

Hi Meena, There is a function available in the Transformer - DateFromDaysSince(date,number of days) , that lets you add/subtract a certain number of days from a given date. The second arguement in the function is of int32 type while the first is of date type. This function is available in the Transf...

Hi,

Also make sure that you have used the right partitioning mode for the Change capture stage. I believe that incorrect modes can also cause problems like this. Suggest that you use the Hash partitioning on the After and Before datasets .

Regards,

The Bird.

Jayant, For generating the surrogate key, you can either use the Surrogate Key stage as Balaji said or as you have done, use the Transformer. Both have pros and cons. If you have to use the surrogate key stage, then you will have to give the start value in the stage properties (i am not sure if this...

Varun, I believe you should be able to do this, the way Ray has mentioned. To your next question, there is no particular stage just for parameterization. It is for this purpose (pass parameters) that the Parameters box is given in the execute command stage, so that you can set the parameter names he...

Hi All, As mentioned in previous post, my jobs are failing with a Job control process (pid 27395) has failed error. Can someone please explain why and when this usually occurs? I am still trying to find why the Load job aborts with this error when run from the script, and runs perfectly fine when ru...

Hi, I am trying to Load an Oracle table, through the director when run the job finishes successfully and the table is loaded, but wiht the same settings, I try to run it from the script, the job aborts giving a fatal error - Job control process (pid 17149) has failed In the Oracle Enterprise Stage -...

Thanks Ray!!! The RT_CONFIGnnn table contains the runtime version of the job design. I suggest you solve that first, as per the other thread. The error that is the subject of this thread may then magically vanish. As you said this error has magically vanished, but I had to delete the current link (o...

Craig, You should be able to search for the key words in the error as it has been discussed here before - this being one such example. I did search on this forum, but didn't find any solution to this. I am pasting the generated osh for this below - # OSH / orchestrate script for Job CopyOfCopyOfIFil...

Hi, I forgot to mention the stage where this error was pointed to, in the above post. The "ProcessFlagCheck" stage is a transformer, and "ProcessFlagUAndD" is the output link to an Oracle Enterprise stage. I am only doing a DateFromDaysSince function in this transformer, and then...

Hi, We are frequently getting the below fatal error in our team - main_program: Data set, file set, or file "ProcessFlagCheck:ProcessFlagUAndD.v": Non-pipe (or non-virtual data set) with .v in its name Since many of us have started getting this error, and all of it seems to have started on...

Hi, When I am trying to save or compile jobs, I am getting this eeror - Unable to write record <Job Name> to file RT_CONFIG 1342 This has been happening frequently now, and has been hampering my developmnet a lot. An someone please tell me what this error is, or how this can be dealt with. Once this...

It looks like you are declaring the same function twice with different numbers of parameters. 0006: extern int32 stripinvalidchars(string inpstr,string termstring); 0007: extern string stripinvalidchars(string inpstr,string termstring,string replace); Thanks Arnd. I think that's the proble. Infact,...