Refresh time

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sureshchandra
Participant
Posts: 92
Joined: Mon May 07, 2007 4:26 am

Refresh time

Post by sureshchandra »

Hi,
I have a source table where in I have data with time stamp.

every day i have to refersh data into target table in a particular time.

how can I insert/update without using hash file concept.

Thanks in advance
hemachandra.m
Participant
Posts: 27
Joined: Wed Jan 03, 2007 1:29 am

Re: Refresh time

Post by hemachandra.m »

Please elaborate your question.
One of the option from my understanding of your question is to use Update/Insert option in the Oracle stage.
Hemachandra
bkumar103
Participant
Posts: 214
Joined: Wed Jul 25, 2007 2:29 am
Location: Chennai

Post by bkumar103 »

If any database load stage like oracle, multiload stage is used
update, insert or delete operations can be performed based on the query.

How are you trying to achieve in your job?
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

How are you loading the data into the table in your job
Mayur Dongaonkar
Participant
Posts: 20
Joined: Mon Dec 11, 2006 10:57 am
Location: Pune

Re: Refresh time

Post by Mayur Dongaonkar »

Are your source table and taget table on same database or on different database ?
Mayur Dongaonkar.
Post Reply