Page 1 of 1

Refresh time

Posted: Wed Aug 08, 2007 10:54 pm
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

Re: Refresh time

Posted: Wed Aug 08, 2007 11:14 pm
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.

Posted: Wed Aug 08, 2007 11:20 pm
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?

Posted: Wed Aug 08, 2007 11:25 pm
by Raghavendra
How are you loading the data into the table in your job

Re: Refresh time

Posted: Thu Aug 09, 2007 12:57 am
by Mayur Dongaonkar
Are your source table and taget table on same database or on different database ?