DSXchange

Thank you for your help.

Cheers.

Hi All, I have a job that does a full extract by a complex join of 15 Plus tables and returns around 2 million rows. Only 1000 of these 2 million rows are actually usable/required. Hence I was looking at sending the 1000 record Id's into the complex query and limit the time it takes. To select the r...

Another option, Try to check the versions of installation. Sometimes, the client version you installed could be different to what you need to install.
Essentially check if there is any difference from a installation or patch perspective. This could sometimes show you funny things.

Thanks Arvind, but I couldn't find a way from the web console.
Anything specific you want me to try?
Thanks

Here's the problem : For Each project, how do I get the Users assigned, their roles and assigned Date. The users are unix user Id's The number of projects are over 200, and users are assigned to multiple projects Is XMETA the best place to get the details. Can anybody help out with the table name to...

Hi, I am importing jobs into a project using a dsx file created for an existing project. I was able to import the project in a scratch area in 20 minutes. The same project when i am trying to import using the project dsx, by creating a new project, it has taken more than 3.5 hrs. what could be the r...

Well, What type of slowly changing dimensions are you looking at ?. Have a look at the documentation for Change Capture Stage, to get the differences between datasets. And based on the code returned from the change capture stage, have subsequent jobs to delete, insert/update based on the surrogate k...

Scenario : Job A : Table A Containing 3 columns is populated fine with checks for Not null, and field length checks. There is a reject link, and it works fine to capture rejects. JobB : The Table A is checked for new records, or altered existing records in the transformer. The transformer has 2 out...

I am curious here. I thought it was a good feature to have : that is when i am importing routines into a protected project, the routines became read-only, and i had to follow the steps as mentioned to get rid of the read-only, then imported the modified routines. I am a bit confused here, is it not ...

Hi Guys, Here is the answer : go to the $DSHOME path execute . ./dsenv execute bin/uv. Then at the command prompt LOGTO <project name> from the dshome , Execute: UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE DSRID = <routine name>; Execute LO. This will then remove the read-only setting, and can the...

Thanks guys, We actually went ahead in altering the routine, to test for existance of a file before deleting. But, now facing a problem in importing the altered routine from dev as the existing routine in Production has been created as a read-only routine. It prompted me to send another SOS.. Cheers.

Hi, We have a set of routines, that were intially imported using the "dsadm" user id, and the project was protected. One of the routines was modified, and to import this routine did the following: 1) the project was first un-protected, 2) tried to delete the existing routine (but its read-...

Hi, We are close to moving to production, and realised that the jobs using routines to remove existing dataset uses the "orchadmin rm < file name > fails as there is no file <file name>.. The routine contains DSLogFatal, if the rm is unsuccessful. so, as alternative, 1) Is there a way to create...

Hi, In case you feel that what amos has suggested is already in place, but still are getting to see the key values as 1, 3, 5 etc.., you might want to do the following : 1. Check if you are checking the key values in the datasets. Because, you are using round-robin method and 2 nodes, when you check...

Hi The following error occurs while trying to shutdown DS. Unable to remove the following shared memory segment(s) during shutdown: m 106000 0xadec7511 --rw-rw-rw- root dstage 17986 8537 m 166002 0xadee7511 --rw-rw-rw- root dstage 17987 8537 Stopping JobMonApp JobMonApp has been shut down. 2 error(s...