Search found 135 matches

by sainath
Tue Nov 22, 2005 2:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run job options limit page
Replies: 4
Views: 2475

HI
For this job
Job run requested
Mode (row/warn limits) = 0/0
Job Parameters --->

is it Means that you can have any number of warnings.
but 1 day this job has failed and next day it run fine.
i could not able to understand why it failed.
thks
by sainath
Tue Nov 22, 2005 1:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run job options limit page
Replies: 4
Views: 2475

HI
this job is run through sequence .where i have to see to know number of warnings this perticular job is set to .

THKS
by sainath
Tue Nov 22, 2005 1:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run job options limit page
Replies: 4
Views: 2475

Run job options limit page

Hi
In one of the job sequence ,one perticular job is runnning with warnings (140 daily) but job never aborted.but in the run job options limit page is set to abort job after 50(default).
can you tell me what is the reason that this job is not aborted after 50 warnings
by sainath
Tue Nov 01, 2005 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage New Version 7.5.1
Replies: 3
Views: 1776

Datastage New Version 7.5.1

Hi In our office we use datastage 7.1.r1.we strictly limited to server jobs. and our jobs perfomance is not good. i want to know how good is new vesion 7.5.1 to us.is there any bugs . This new version improves job perfomance.we are also thinking of upgrading or database from 9i to 10g. please share ...
by sainath
Wed Oct 26, 2005 6:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage version
Replies: 1
Views: 1157

datastage version

Hi
which version of datstage is compatible with oracle 10g.
THks
by sainath
Wed Oct 26, 2005 4:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Version
Replies: 2
Views: 1645

Datastage Version

Hi
I am wondering which datastage version is compatible to oracle 10g.
THKs
by sainath
Mon Oct 24, 2005 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job failed
Replies: 1
Views: 1340

Job failed

Hi I want to change job parameters for a perticular job sequence from cycle date to start date and end date.i changed in all jobs and job sequences.but when I run the job I am getting following error.the job sequence is aborted with following error. DWSLoad..JobControl (@LoadDimensions): Controller ...
by sainath
Sun Aug 21, 2005 8:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: slow changing dimensions Type 2
Replies: 22
Views: 7369

Re: slow changing dimensions Type 2

Hi I implemented slow changing dimensions type 2 in server jobs .where i updated and inserted the same records by designing two seperate jobs. Update job where i have to update the exp date insert the record Requirement. IF SAME CODE AND DIFFERENT NAME Code Name effdate expdate AAA CANADA 2000-01-0...
by sainath
Sat Aug 20, 2005 10:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: slow changing dimensions Type 2
Replies: 22
Views: 7369

slow changing dimensions Type 2

Hi I implemented slow changing dimensions type 2 in server jobs .where i updated and inserted the same records by designing two seperate jobs. Update job where i have to update the exp date insert the record Requirement. IF SAME CODE AND DIFFERENT NAME Code Name effdate expdate AAA CANADA 2000-01-03...
by sainath
Wed Jul 13, 2005 7:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installation of Datasstage 7 in XP
Replies: 7
Views: 1972

Hi

You can install datastage on XP professional with SP1.it will not work
with SP2.

sainath
by sainath
Wed Jun 01, 2005 8:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: General idea for job design
Replies: 1
Views: 1150

General idea for job design

hi

In my company we have shifts job of employees.these jobs are sheduled
to run daily.i just want to know how can we design a job in datastage which give total count of records daily or monthly and also check with previous records and tell whether it is loosing any history of records.

Thks
by sainath
Tue May 31, 2005 8:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Type 2 slowly changing dimensions
Replies: 1
Views: 1255

Type 2 slowly changing dimensions

Hi I an new to datastage and i want to implement type 2 slowlychanging dimensions where i have to insert and update same record.I created 2 jobs insert and update I conditions : 1.Isnull or carrier name not equal then INSERT 2. UPDATE . not is null(c0de) and if i have new data with same code and dif...
by sainath
Sun May 15, 2005 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINES
Replies: 3
Views: 1622

Routine

Hi
I agree with ray that since the input date is timestamp first i have to use
ICONV then OCONV.Thank you very much for ray and Arwd for quick reply.
sai
by sainath
Fri May 13, 2005 8:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINES
Replies: 3
Views: 1622

ROUTINES

HI
i am new to datastage.I want to know how to write routine for following
situation
expiry date( in timestamp) = effective date - 1.i tried using iconv and oconv but i am not able to get result.


thanks
sai
by sainath
Thu Dec 30, 2004 10:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aggregator aborted.
Replies: 1
Views: 1112

Job aggregator aborted.

hi

when ever i run server jobs i will get warning message that job is aborted.actually what is it?how can i solve this problem.

sai