DSXchange

ray.wurlod wrote:What key are you using for the lookup? if its only 1234 - note that all of these have 1234 - then the first one found is returned. You need more specific information for this kind of lookup.

I am using Make and incorrectmodel as Key

Hi, I am facing a strange problem when using OCI lookups. I am having an oracle table which has all the makes and models of cars. The table has three columns acutalmake, acutalmodel, incorrectmodel For eg MAZDA MX-3 MX3 MAZDA MX-5 MX5 MAZDA MX-6 MX6 MAZDA RX-7 RX-7 MAZDA RX-8 RX8 We have a file that...

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 thi...

If the format of the file is same, then following can be done: The job will take the file name as parameter and will use this job parameter while reading the file thro' folder stage and at a time will process only one file. Write a shell script, which should be called to check if any file is in dir...

If you are having 2 cols in folder stage: 1st as filename and 2nd as column which will contain the XML doc then... After the folder stage instead of putting XML stage, put a transformer. Folder stage has 2 columns as output: 1st filename and 2nd column which will contain the XML data. In the transf...

Hi I have a problem with using folder stage. I am using a folder stage to pick up multiple xml files and convert them to CSV files. So this is my job FOLDER STAGE --->XML Reader---> Sequential File stage My problem is, I have multiple XML files in the folder that I am using. So I need to read each x...

I did try the folder stage before. But I was getting other problems such as Unable to open folder containing teh file xx. Also with the foder stage I was unable to even get it validated. tried the seq and at minimum I got it validated, just having this final problem about XML source column. Even I ...

Did you restart the DS services after adding the entries. Even I had faced the same problem. So what has to be done is , after adding the entries, RESTART THE DS services.
Hope this helps

Hi all I am facing a problem with on e of the server job. I can see the following info in the log. stastaXelusPLNREQMTExt..xfmMap1: C Stage PlugIn function "Get" required stastaXelusPLNREQMTExt..xfmMap1: |-2| ds_loadlibrary: error in dlopen This job is having DB2 plugin and also I am not ...

Ever seen SQL like this? select (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_criteria... ) "FIRST_METRIC", (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_other_criteria... ) "SECOND_...

Really easy once you get used to it.... Select a.Count as FIRST, b.TOTALCALC as Second from (SELECT COUNT(*) COUNT FROM RNKT0.ATTENDANCE ATTENDANCE WHERE ATTENDANCE.CUSTOMER_ID = :1 ) a, (select count(distinct(CLUB_ID)) TOTALC FROM RNKT0.ATTENDANCE ATTENDANCE WHERE ATTENDANCE.CUSTOMER_ID = :1) b Ex...

Ever seen SQL like this? select (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_criteria... ) "FIRST_METRIC", (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_other_criteria... ) "SECOND_...

If you want to improve the performance of the queries without using temp tables (depending upon the DBMS being used) , you could rewrite the query that Ken proposed to put the queries into the from clause instead of the select clause. That will improve performance on DB2 and Oracle normally. Accord...

PhilipDuPlessis wrote:Point taken... Ken has it spot on in terms of the performance on the query.

Thanks a lot for all your suggestions

Ever seen SQL like this? select (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_criteria... ) "FIRST_METRIC", (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_other_criteria... ) "SECOND_...