DSXchange

Just to give you an Idea this is how we are doing it. currently we have 80 dimensions and 5 facts alot more facts to come in phase two. What we did was create a local parameter called #TableName# which is local to each job. Since each job is specific to a table the name will never change at run time...

Well I am sorry to hear you think the xml files are a joke. I use them, have been using them for 10 years. I wrote a series of jobs which parse all the xml files and loads the data into tables, relational of course. I then use a reporting tool like Report Builder in this case since the tables are in...

Its apparent that if it runs in one environment and not the other then you need to figure out what the differences are between the two environments.
The config is just the start.
If they are different servers then are they installed and configured the same as well.

Well first if it works on a single node config and when you move it and try to run it on the 4 node config it fails. Then I would first start simple. Use a simple 1 node config on the test project. If that works then you proble need to look at the config. So I have a couple of questions. 1) Are you ...

Also I would stay with the switch in stead of the transformer. The transformer is the easy way out but the most costly in terms of performance.

Also you might try the option if not found set it to output and attach a reject file

my code is
case=N=0
no quote
no problem

options
If not found = output
and I have a file on the reject link.

Node pools and the default node pool Node pools allow association of processing nodes based on their characteristics. For example, certain nodes can have large amounts of physical memory, and you can designate them as compute nodes. Others can connect directly to a mainframe or some form of high-spe...

Is there a reason you have only one node? This is one of my configs I have a 4core cpu. 12G mem three drives C:\ Where datastage is installed and used for scratch. D:\ San Drive E:\ San Drive { node "node0" { fastname "DC1VMASCEN001" pools "" resource disk "D:/DW_P...

Yes you can install bot 8.1 and 8.5 clients on the same machine. The multi client tool can be used to access either version. If the client tools are installed on a vm server though it will still work but there are some inderences if two developers are on diff versions. I am running 8.01 2 servers an...

I think the problem is with your config.apt file If I am looking at this right you have four nodes writting to one controller. Your scratch disk and resource disk is the same. Or are these diff. mounts on different controllers. First thing I would do is move my scratch disk to a different filesystem...

Well I assume you do project backups on a frequent basis ??
Restore the project.

Then if you really don't want it delete it the right way.

And actually
We have two seperate jobs Inserts and Updates
We don't use upsert
but if you .do the before post would be the better way

I would do Insert then Update as opposed to Update then insert.
Less scanning.

*------------------------------------------------ *--- Subroutines *------------------------------------------------ CompileJob: Key = DSR.SUB.JOB.RESERVE Arg2 = JobName Call @SUBR(Key, Arg2) Call DSD.Init(MyJobNo, Dummy2) If Key <> "" Then JobsNotCompiled<-1> = JobName:" ":&quo...

Another thing I might recommend The deadlock daemon can be started to release locks and abandoned shared memory segments for processes that are terminated via the UNIX kill command or abnormally due to an unforeseen event. To start the dslockd process edit $DSHOME/dsdlockd.config and set the start f...