DSXchange

We also have a star strucutre and for the most part the process seems to work aside from the amount of time it takes to rebuild all of the bitmaps at the end of the run. The main issue we have is that we try to update rows in the table for security purposes and we will get different results for the ...

Yes its an Oracle DB we are loading and your right its not really a DS issue other then the fact that unless you knew what to do with the indexes on the table you were loading your DS job would not work. For example if you try to load inserts or updates to a table and the bitmaps were left enabled t...

The data architects at my company have decided that the BITMAP index is the best index to use for our DW and I am wondering if that is such a good idea considering we have updates rather frequently. I have read several articles on-line that state not to use bitmaps if you plan on updating excessivel...

We have a chain of DS-jobs that build datasets which are used for different jobs. When changing a dataset downstream (say we add a new field) and then we try to re-validate the job the job fails validation because the field does not exist in the dataset. Is there a reason that during validation the ...

I tried and tried and I could not get it to use a field with a NULL possibility in the transformer constraint. As a work around I used a modify stage prior to the transformer and converted the NULL's to a usable value which I then used in the constraint. OLD constraint logic isnull(FIELD1) or FIELD1...

Is it possible to exclude or include data within a transformer constraint based on if the field is NULL. Example below isnull(FIELD1) or FIELD1>FIELD2 or FIELD1=FIELD2 in the transformer logic itself (not the constraint area) I can get around the nulls by saying something like if isnull(FIELD1) then...

We figured it out. Within Appworx instead of having a module with just a call for a JOBNAME we changed it to a call for the JOBNAME.INVOCATIONID. Thanks

We attempted to assign a variable and pass it back into the DSJOb but the invocation id is not really a parameter in the job properties. We can set a paramater and pass it out but it has to be pointed to somewhere in DS for it to be used. An example of some of the script is below I would think we wo...

We are attempting to call DS JOBs from Appworx and have a perl script that will directly call a DS job name and kickoff the job. The issue we are having is that for our DSJOBs that require invocation id's we need to establish the invocation id variable in the perl script and I am unsure what stores ...

We have been having the same issue and I am just curious if the fixes really worked and if any issues have since deveolped. Basically the upsert logic does not seem to work correctly all the time for some of our jobs. It appears to give erroneous 1403 errors on an upsert vs insert and -1 errors on a...

Finally figured it out use ASFLOAT(1)/ASFLAOT(2) to get .5.

I am trying to do a simple division step in the transformer but the result is zero for anything that is not a whole number. The output field is set to handle decimal (10,2). For testing purposes I had it try simple stuff like 31/31 and it gave me 1 10/2 and it gave me 5 100/50 it gave me 2. Any othe...

Luckily these are unedited fields so the best we can do is get a lastname and a firstname. I am surprised by some of the things they have in there

I actually understand that and wish I could have figured it out. Thanks for the help.

What if the data looked like the below? colian,john bbb donald,sam 1. first row contains the last name,first name' 'middle_initial 2.second row is lastname,firstname' 'middle_initial I can grab the last name easy enough but is there away to tell it to grab whats to the right of the first comma it se...