DSXchange

I am having 5 jobs which run sequentially namely validate, default, transform, lookup and load. From Validate to lookup, all the jobs ran successfully and while load job was running it throws an 'fatal warning' of below:- 'Unable to find SoftwareResourceLocator start point'. I reset/stop the load jo...

No, Chulett. I didn't check for the phrase mentioned by you. I need to check now becoz as this is the important file to be generated for going alive for my project. So what I did is, I created a copy of the 'problem job' and compiled and ran the job. It worked fine. Actually what happened is, I am u...

Hi, I ran the first job whose output is the input to second job. when I tried to run the second job it is throwing the compilation error of 'cannot get exclusive access to executable file '. When I opened the input of 2nd job it has all the records of first job. What could be the problem. In directo...

Chulett, As mentioned by Ray in the forum, when I zoom out ( minimise) and I found one unattached link present in the farther end of the screen which is not under screen view. This mistake happened because I copied a job from one project to another and deleted the stages not required for the present...

Thanks, Chulett. I got the post. After fixing this, I will get back to you.

When I compiling the job, I am getting the following error " This job contains one or more unattached links, all links must be attached before compiling" I checked and all the stages in the job is linked to each other. When I press the 'Show Error' button it is not highlighting the stage a...

Thanks, Mike.

Yes. You are correct, Mike. If I didn't include the dependent items, it is taking only very less time.

But is it correct 'not select the include dependent items' when we are going to reuse the parameter set, routines created in project 'A' to project 'B".

Hi, I have created a new project 'B' in the same Unix box where project 'A' exists. I need to copy all the jobs, parameter set, routines from project A to B. When I tried export the jobs of project A using 'Datastage components' it took nearly one day for exporting everything. Is there any easiest m...

Thanks. Instead of using universe stage I tried with sort and transformer ( stage variable ) for concatenation. It worked.

Ray, Incoming date is in the format of 20081001 and business wants to see in the format of '01/10/2008'. Chulett, I did as per your suggestion as the incoming date is always having 8 digits. It is working fine. Thank you so much. DEFAULT.AC_COMPLETED[7,2]:'/':DEFAULT.AC_COMPLETED[5,2]:'/':DEFAULT.AC...

My input column 'AC_COMPLETED' is in the date format of '20060801'. How to convert this string into the date format of '01/08/2008'

I am having the input columns with datatypes of COLUMN NAME-DATATYPE-LENGTH 1)ASSETNUM-VARCHAR-12 2)DESCRIPTION-LONGVARCHAR-4857600 Condition is 'If the assetnum is repeated, then concatenate all the description values Eg- assetnum description 1 apple 2 mango 1 mandarin Ans should be (output) - Asse...

The problem is resolved and I did like below I created a routine aaifNullReturn(Argument,Result,alternate) Created stage variables like below inorder to concatenate with earlier values. 1)aaIfNullReturn(hash_Biseps_Retailer.AD_COMPANY,"",hash_Biseps_Retailer.AD_COMPANY)-stage variable -->C...

The problem is resolved and I did like below I created a routine aaifNullReturn(Argument,Result,alternate) Created stage variables like below inorder to concatenate with earlier values. 1)aaIfNullReturn(hash_Biseps_Retailer.AD_COMPANY,"",hash_Biseps_Retailer.AD_COMPANY)-stage variable -->C...