on 05-08-2008 6:46 AM
Hi Experts,
We have one ODS having update routines , daily DELTA loads are ruuning in production system.Now we got one requirement like need to develope another ODS with different update routines on the same infosource. is it possible ? if we do means is there any effect for 1st ODS ? please suugest me how to do that ..its in production system ...little bit urgent..
Thanks & Regards
pcrao.
Hi,
You can initialize the info package by creating a new one it doesn't affect the ODS1, the Infosource can be assigned to other DSO also.
But make sure both the data loads will happen at different times.
Rgs,
I.R.K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravikanth,
We are allready loading deltas daily in to ODS1(having diff update routines). Now we have new requirement to craete ODS2 on the same infosource with different update routines.If we create means is there any effect for the ODS1 deltas ?How to intialize the ODS2 ? We are doing in production system, So we need to do carefully. Please suggest me.
Thanks & Regards
pcrao.
it may usefull for me. Thanks for the reply.points assigned...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
just create another ods2 ,but take the infosource as template and then at the time of update rules ,take again infosource as template.ok.
and then go for creating infopackage and schedule it.
before scheduling check the time of scheduled time for the ods1 as one of our frnds said.
if u want any update routines first do them before scheduling.
thatsit..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.