DSXchange

Thanks Narasimha,

The test is succesful........ Job completed in just 4 min and target sequential file contains Lookup column value.

But whats wrong with OCI..still in question????????

Regards.

Hi Duke,

I cannot access your site http://www.duke-consulting.com. and hence cannot your any tips and ETLStats. Can you help me.

Thanks & Regards,

ITsME

Thnx all, Enabling Read Caching in the lookup works fine ... :D ...But :( What happens is that my job starts very well with 6350 rows/sec and it loads 1.5 million rows in just 5 minutes. After this the rate of rows/sec goes down and the remaing 1.1 million rows load in 2 hrs with final rate 271 rows...

Hi Ray,

1. The hashed file contains 4 columns...

Column Type Key
Col1 Varchar Yes
Col2 Decimal Yes
Col3 Decimal No
Col4 Timestamp No

2. No. Not enabling read cache

Thanks & Regards.

Thanx for response, Lookup table contains 70 records. It has composite key on two columns. I am not receving any type of error. Job finishes successfully. The structure for job1 (without use of lookup) is equal with job2 (lookup used). Job1: SeqFile ---> Transformer ---> Oracle OCI Job2: SeqFile ---...

Hi all, I have a 640 MB sequential source file. I want to extract and load data into dw table with only one lookup that inserts description of code in dw table. Without using any lookup my job extracts and loads data in 5 mintes . But when i use lookup (in the form of hashed file or table), my job c...

Yes......Attachment is not attached and in BODY "something*" about file that was trying to send as attachment. *something --Unique-Boundary-14207-34801 Content-Type: application/octet-stream; name="c:/mydir/myfile.txt" Content-Transfer-Encoding: base64 Content-Disposition: inline...

Hi, I didnot make any change in template file. The receiver is on the same mail server. Consider the following arguments:- ToAddress = "myfriend@mycompany.com" FromAddress = "me@mycompany.com" Subject = "Its Test Mail" SMTP Server = "mailserver.mycompany.com" ...

Hi to all, When I use DSSendMailAttachmentTester routine by giving all arguments it works well .... the receiver recieves email but without attached file. Also instead of message I typed in BODY, the following message is displayed in email. ***********************************************************...

Ray Thanks a lot :D . I got the solution by releasing jobs.
Any how i have a suggestion for IBM to please mention in documentation that 'A job must be RELEASED to be used in OPERATOR role. Otherwise it will not be available'.

Thanks to all.

Regards,

ITsME

Ok. You can create your own sequential file and write data to this file after job completion and then in other job extract this data from file and load into database table..........Do all this in a sequencer. Use code written in built in routine and customize it..... :D Hopefully this will help you....

Think how you can insert job endtime while still the job is running.
You can do it in After Job Routine by in your routine.

Regards,
ITsME

Thanx to all but my problem is still there........ I have tried a lot of time.....when i change role from OPERATOR to DEVELOPER....useroperator can view and run jobs but when i again change this role to OPERATOR and login again......now useroperator can not view any job. Please help me i am stick wi...

Thanx..

Can you please tell me the command or any sample code to write a routine for this.

Regards,

ITsMe

Hi to all,

I want to execute sql statement or database procedure before DS job run. How can i do this.....May be my question is very simple.....but i dont know.

Thanks to all.

ITsMe