DSXchange

Thanks Ray,

I will try that and see if it helps me


Regards,
Kishan

Thanks Ridar, I am dealing with Server Job version 6.0 Its possible in Mainframe Job and Parallel job where they have Lookup stage where you can do this WHERE Table.Number1 = :1 AND seq_file.date between Table.date1 and Table.Date2. I am not sure if it is possible in Server Job May be its possible ,...

Thanks for the quick response the sequential file has a number field and a date field the hash file has 2 number fileds and 2 date fields I need the seq_file.NUmber = hashfile.Number1 and seq_file.date between hashfile.date1 and hashfile.Date2, if this condiiton satisfies i need to get the hashfile....

hi everybody, i dont know if any of you had this situation i am sure someone or other has done this before i have to do a lookup between a sequential file and hash file I have only one field that need to be equal and there is a date that needs to be between two date fields in the hashfile the table ...

Hi love,

i figured that out and got rid of the problem but the problem for which i started is not yet solved

thanks for your reply

I will look into this but the tablename problem is taken care

Kishan

Hi, I am using an User_defined query and this Oracle OCI plug-in is used as the reference for a look up I tried using Hash file since the table has a composite key and i need only one of the field to be used for lookup, its removing duplicates based on the single column key now when using the OCI pl...

Thanks a lot,

the job ran fine after i set the Rows per transaction to 1
and completed faster
Your explanation made it clear why this was happening

Regards,
Kishan

Thanks for the immediate response,

By lowering the commit frequency, you mean increase the rows per transaction in transaction handling

Kishan

Hi I am updating an oracle table Sequential File looked up against a hash file, the matched records written to a Sequential file, the rejects update the oracle table As I am dealing with millions of records, i am using link partioner and the transformer where the lookup takes place I am updating the...

Thanks everybody,

I got the cost from explain plan and tried to optimise the query but its still slow
I am dealing with two tables with 20 M records joined with a table with 300 records

Since this table is small, I will use a hash lookup rather than direct join

Thanks again
Kishan

Thanks for the Immediate response Bala, I didnt do any cost estimation before the first run Since this job was taking long time to finish, I was running the estimate plan to find where I was having problem Then I was trying to change the design to accomodate this table when i found this mistake Now ...

Hello everybody, I made a change to an existing job This job has a OCI stage which fetches data from the join of 2 tables This took like 5 hrs for me to run I added another table making this a three table join but forgot to import the table definition of this new table FYI, i am using a User_defined...

I had similar kind of error
But something strange was goin in the Server/Database
So the Admin just restarted asking all of us to get out of the box and it all worked fine after that

Talking to the DBA might help

Kishan

Hi everybody, I had a similar problem Is it good to include a sequential stage or IPC stage between transformer and Link Collector? I already had the Inter-Process turned on with default settings Mine worked with the sequential stage in between but the time taken to run this job was much longer Then...

Thanks Kenneth,

I will look into it and get back with you
But what i noticed is that the jobs with Link Partioner / Collector run slower than the simple straight forward job

Thanks again

Regards,
Kishan