DSXchange

Thanks Ray.

ray.wurlod wrote:That's a feasible configuration file for a four CPU machine, but note that processing nodes are not related to CPUs. For example if monitoring indicates that no CPU is exercised to more than 50% of i ...

Hi Ray, Thanks for the reply. I just want to know that how can I leverage the performance of four CPU's with one configuration file. As I've a 4 CPU's with the name of Fid1, Fid2, Fid3 & Fid 4. Do I only need to copy the same format of default configuration file for four times and just need to c...

Hi there,

I need to add nodes for multiple CPU of my server. Will appreciate if somebody will let me know the syntax of adding multiple nodes in the configuration file.



Thanks
Javed

Hi Brian, Thanks for posting. As I'm using Sybase IQ as the DB so I think sparse lookup is not the option :( Thanks Javed What kind of DB stage you are using to perform lookup operation with Lookup stage? If Oracle/DB2 Enterprise stage, try Sparse Lookup instead of Normal Lookup. Sparse lookup would...

Hi Kunal, Thanks for replying. If I'm running the job with only 4 lookup so it's working fine and these reference tables are not same on every run. The issue here is on every run the job takes the reference tables randomly. I strongly believe that this is the memory problem. Let me try some other al...

Hi Kunal, What do you mean by your comment disabling the operator combination when using two lookup stages" Could you please elaborate your comment. I'm not getting any records as job is waiting for the 4 tables to be run. It's showing "delayed metadata" in the job log for the tables ...

Hi Birendra, I tried splitting the tables with two lookups but still facing the same problem. I checked the job monitor after adding two lookups and found that the reference tables from both lookups are loading at the same time. I think this is the issue as if it's load the reference tables from fir...

Hi there, I've a job which is linking 1 source table with 30 reference tables with lookup stage. But the job is not reading from the source and 4 reference tables. I checked in the job monitor and it's showing source+4 unread reference tables in ready status and rest in running status. My reference ...