DSXchange

Hi,
I'm evaluating a job for optimization/performance etc, and I see that there's a JOIN being used. One of the reference file can be upto 6MB. Is it advisable to go for LOOKUP in place of this JOIN ?
Thanks

Hello, I'm having difficulty in accessing a Job Parameter in a Shared Container. The Shared Container, as such, in its Job Properties, has no Job Parameter defined. The Parent Job calling this Shared Container has few Job Parameters, which I would like to access in a Transformer in the Shared Contai...

Hi, Couple of jobs in production failed for our In-Job Controls. Contents of phantom output file => DataStage Job 362 Phantom 4901 EFF_Extractor.Input_File not found in RT_CONFIG (2). EFF_Extractor.Transformer_1 not found in RT_CONFIG (2). EFF_Extractor.Input_File not found in RT_CONFIG (2). EFF_Ext...

we are receiving international data Is there any spceail charachter set you are receiving? You need to check for your project's NLS map and collation locale setting. If you get any error due to unhandling of special character while running job, then you need to set appropriate setting for your proj...

gateleys wrote:Couldn't help but notice the new DSX logo? Looks cool ..... more "In your face" kinda look. And check out those 'solar flares' emanating from the logo. Hmmm!!

Is there any other changes?

Change to the DSXchange logo is cool

Hi, For loading large volume of records from a sequential file to a DB2 database table,I noticed that the speed inreased significantly(it almost doubled) if I checked the "Allow Multiple Instance" chek box. I just want to know if this would inrease overhead in some way or would it have an...

How do I choose between the compare, difference, and change data capture stages. It appears to me that the change data capture stage does everything that compare and difference do so I have always used change data capture. Am I missing something? I hate it when I am missing something... Yes Change ...

Hi all. I am using an STPPX stage within a shared container and I'm having problems passing parameters to this stage from the properties tab in the shared container. In the STPPX, I've parameterized the db credentials, name and source. When I run my job I get the following warning and fatal error. ...

I am a newbie at this, it is my first post, so please bear with me. I do a tremendous amount of pivoting in the work I do, and have not been very impressed with the pivot stage. I have 2000+ input formats that I have to standardize into one of a few standard formats. These input formats range from ...

I have a question relating to job performance, one of the job is doing a normal lookup directly from the oracle table to retrieve ID, there are over 9 million records in the table and this lookup causes the performance to decrease. how can i increase the efficiency of this job? Thanks Yes...If look...

What I want to do is to remove the duplicates based on UIDCONTRACT, and obtain the first row i.e. the row with priority 1. I thought about using an aggregator stage bu that just brings back all the rows as I cant leave out the description. You can achieve the same with just Dataset-->Sort-->Dataset...

Hi , My requirement is I am getting 3 source files with same meta data and I have to design one job in that I have to load these files one after the other.In the Target table I have to append the Seconefile Data to the first file and so on.. While reading the first file if i encounters any problem ...

I'd be surprised if it actually takes all that time to do the physical compile. We've seen situations like this in the past, where the compiler license limits the number of concurrent compiles - sometimes even restricting it to one user at a time. This seemed to translate into long wait times for t...

Yes...Pivot performance is considerably poor. You can go about building BuildOp Stages using c++ code whatever you use the pivot stage for.

Ray, Initially the job started compiling better with the change of funnel option but then it started getting slow again. I removed the funnel stage altogether and it is compiling much better now. There almost 10 links to the funnel does this have to do with anything.... except for this job rest of ...