DSXchange

Hello sir, I need to schedule a batch with different dated in each month. For example in december i need to run this batch on dec 20th and dec 31st and january 4th,february 5th etc... we have all these run dates in the oracle run_date table. Can you please helpme out on this issue. Thanks in advance...

Hello sir, I am loading 12 million records of a mainframe COBOL file having 800 record length into a Oracle 9i table. In that file we have lot of comp3 fields and comp fields.In the transformer i used data type convertions to split into columns. Every thing looks good. But i am getting performance i...

Thank you very much.I got the solution.I appreciate your help.

Thanks
Reddy

Good morning guys,

We have Datastage on Windows server C:\ Drive.Now we are getting space problem on C:\ drive.Can i move only projects folder from C:\ to D:\ Drive.Please advice me.

Thanks in advance.
Reddy

Thanks for quick respond.

Once i combined all 3 files i am sending this file to user but they are telling they are getting problems with line feed terminator.
because of small file i am deleting manually last line.

can you help me on how to remove last line in windows.

Thanks
Narasa

Sir, I am concatenating 3 files using exec command stage like this copy D:\Sequential_Files\CREATEHEADER + D:\Sequential_Files\CREATEDETAIL + D:\Sequential_Files\CREATETRAILER D:\Sequential_Files\BAH_HR_yyyymmdd.txt but at the end of D:\Sequential_Files\BAH_HR_yyyymmdd.txt file i am getting carriage...

Sir,

One of my batch job which is taking backup of all jobs in a project is running continously from last 24 hours.I tried abort this job also.
Even though this job is running.

Can you please help me out on how to stop this.

Thanks in advance
Narasa

Hi Guys,

I am loading 15 million data from flat file into a oracle table.

Currently it is taking almost 4 hours.

Can you please provide me suggestions to improve performance.

Thanks in advance.
Reddy

Thanks for reply.I went through Kim's etlstats but when i used DSJobReportDb for getting rowcounts i am getting mulitple rows. suppose if i have source---IN---->transf-----OUT--->target i need job name,IN Count,Out Count,elapsed Date and Time in one row. Can you please help me on how to get a single...

Hello Guys, We have almost 300 jobs which was in 10 job sequences.I have to get jobname,start date,start time,end time,elapsed time,input count,output counts,jo status data from all these jobs and load data into audit summary table. Can you please help me how to design to get audit counts at runtime...

Ray,

I am going follow all your steps and i tested on one job it worked fine.


Thanks for help.


Reddy

Hi Ray, As per your valuable suggestion: 1.I created new job and compiled it and get the new RT_LOG number 2.Using DS_JOBS command in DS ADMINISTARTOR i am getting RT_LOG numbers of all jobs in this project 3.how to and where do i use xcopy command ? Can you please help me out on 3rd step. Thanks fo...

Hi Guys,

I have 700 jobs in my project.Even when i try to exporting these jobs i am getting same error.

Can you please helpme out how to fix this problem


Thanks
Reddy

Hello Sir,

Because of space problem on QA server we deleted RT_LOGnnn files of almost all jobs.but when i try to open the job or compile the jobs we are getting "Failed to open RT_LOGnnn file) error message.

Can you guys please help me out on this.

Thanks in advance
Reddy

Thanks for your quick responses. Source and target both are Oracle. In the source for a particular column they defined it as long varchar but when i used same matadata i am getting "OCI_INVALID_HANDLE" error but when i changed the column data type to varchar data truncation problem happeni...