DSXchange

Hi,

You weren't far out with your original idea.

Here's what I use: (@PARTITIONNUM+1)*10 : @OUTROWNUM

Use @OUTROWNUM rather than @INROWNUM to aviod problems with funnel stages etc.

Hope that helps!

Cheers,
Bob.

As it's a unix flat file would the unix command "wc" not suffice?

Hello, I have a job which is identical in development and production. In production it works because the partitioning behaves correctly on the two join stages in the job. In development the job doesn't behave correctly and produces slightly different results each time I run the job. I have actually ...

You ask "3) Any other feasible way...." If you mean is there any other way of retreiving job stats you could look at the database XMETA.DSODB which contains all this information. DSODB is quite easy to understand and here's some SQL you can try: (Hope it helps!) select fjr.runid, je.jobid,...

Hi Guicar, I have seen this sort of problem before, even to the extent that there were 4, 5 or even 6 double characters in the data! I solved the problem by using the sed command: sed s/'"";'/'";'/g input file1 > output file2 sed s/'""'/' '/g input file2 > output file3 This ...

Hi dj, I haven't used qsav for a while, but my recollections are that the results differ depending how you pass the data in to qsav. If you send in distinct street, city, state, zip country columns you get the best results assuming the columns contain the correct data, eg. you haven't got street and...

Hi Guys, I think this is actually a windows problem, but I'm wondering if anyone else has come across this problem and knows how to get out of it. I am using a laptop with a second monitor connected via the "extended desktop" option. Normally, all works well but occasionally due to the hot...

Hi Robert,

Perfect!

Many thanks.

Bob.

Hello, I am wondering if anyone has successfully used the IA API to run column analysis? I have used it successfully to run DQ rules and extract the results, but I am struggling to use it for running column analysis. Here is the xml structure the api uses and the part I am not sure of is the "C...

Hi Robert, I am exporting the Data Rule Definition and the Data Rule using the export and import option within IA on the Quality Console. I don't know of any other way, is there one? For this particular exercise the rules are being execured by DataStage jobs but that's by the way really. Kind regard...

Hi, I am having a couple of issues with data quality rules: Firstly ===== I have recently made some changes to a data quality rule: Definition: DRD_CUSTOMER_NAME Data Rule: DR_CUSTOMER_NAME When I publish the rule I get: Definition: DRD_CUSTOMER_NAME1 (new version) Data Rule: DR_CUSTOMER_NAME (no ch...

Hello, I am trying to retrieve user role information such as "DataStage and QualityStage User" from xmeta because the reports don't appear to provide that level of information. I can see some of the tables which are obviously part of the answer such as ASCLMODEL_USER, ASCLMODEL_USERCREDENT...

Might be for one of several reasons: Your expression DeptNo=10 might need to be DeptNo="10" if the column is a varchar There may be trailing/leading spaces in the column. Insert a transformer before the filter and trim() the column If the file came from a windows system the last character ...

I have a job which reads an xml column from an SQL Server table successfully on Red Hat Linux.

However, I had to add the following environment variables to the job:

$APT_DEFAULT_TRANSPORT_BLOCK_SIZE
$APT_PHYSICAL_DATASET_BLOCK_SIZE

and set them both to 3000000 (3,000,000)

Hope that helps.

Bob.

Always restart the top level sequence only. It will work out which sequences and jobs need to be skipped or restarted.