Search found 8 matches

by seeta
Mon Jan 30, 2006 12:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incremental Loading
Replies: 3
Views: 2375

Incremental Loading

Hi,

I am new to DataStage.I want to do Incremental loading that is I want to see the history data from the last run and if any update is there in data I want to update the data and insert the newdata in latest run.How can I do this
any suggestion would apriciated

Thanks
by seeta
Mon Jan 16, 2006 12:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: STOREDPROCEDURE
Replies: 6
Views: 3481

STOREDPROCEDURE

Hi,


I wrote one storedprocedure I want to call that in my job.Which stage can I use to call the stored procedure into my parlleljob.Is this posible are not?

Thanks
by seeta
Fri Jan 13, 2006 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SHARED CONTAINER
Replies: 1
Views: 1190

SHARED CONTAINER

Hi,

I have a question .Is there any performance degradation in job runnig if I use a servershared container in parllelextende? What are the limitation for servershared container to use in parallelextender.

Thanks
by seeta
Mon Jan 02, 2006 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: slowly changing dimensions
Replies: 3
Views: 1986

slowly changing dimensions

Hi

I am new to DataStage.I am working on datastage7.5 .I want to implement slowly changing dimension tables.What I need to do to implement those tables.Do I need to create surrogate keys or do I need to do anything else.

Thanks
by seeta
Thu Dec 22, 2005 5:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incremental Load
Replies: 6
Views: 2820

I am loding from seqential file stage to oracle database,I am loading data comming from source.
I want to increase the load data by date
by seeta
Thu Dec 22, 2005 12:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incremental Load
Replies: 6
Views: 2820

Incremental Load

Hi
I want to load more records for the same job next day what I want to do to increase the records for next run.
Is there any way to increase the load for next run

Thanks
by seeta
Wed Dec 21, 2005 8:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trigger Column
Replies: 2
Views: 1688

Trigger Column

Hi,
I would like to know about aTriggerColumn
If anybody knows let me Know about TriggerColumn

Thanks
by seeta
Wed Dec 21, 2005 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOW TO COMMIT AFTER EVERY 1 MILLION RECORDS
Replies: 2
Views: 1918

HOW TO COMMIT AFTER EVERY 1 MILLION RECORDS

HI
I want to COMMIT my records after 1 million row of data in datasatge ,Is there any way to COMMIT in datastage.
I know how to COMMIT in DataBase

Any help would appreciated
Thanks