Question:
I am loading data from ods1->ods2 with a start routine.
When I right clink on ods2 and open the inforsource to execute I got the following err.
ODS1 is already loaded and data is active.
Help me in this.
Thank You
Transfer structure is not yet active
Message no. RSM005
Diagnosis
The transfer structure has not yet been created or not yet activated.
Without a transfer structure the data cannot be accepted from the source system. Therefore, this request of the data is not possible.
Procedure
In the Administrator Workbench maintain the transfer rules for this source system and activate them.
Answer:
pretty confusing post to me (you're loading from ods1 to ods2 so why would you go into the infosource of ods2? why go into the generated infosource in any case?), but try to right-click on the concerned ODS and say "Generate Export DataSource" ... this should generate all the structures again.
Answer:
Thank You TFR
Answer:
For the same ODS1 to ODS2.
Can I load ODS1 with a couple of full loads and followed by few deltas and then execute a full load of ODS2.
I need to load 6 yrs worth of full loads and 2 deltas; and using this ODS1 generate a solidated ODS2.
I do not want to trigger ODS2 load for each full/delta load of ODS1.
Answer:
Sure, nio problem: just make sure the source ODS (where you're perfroming the different loads into) doesn't have the setting "Update data targets from ODS object automatically" flagged on. This way you can load into it, without it automatically starting the load to it's subsequent objects.
Then at any point in time you want, you can perfrom a load (full/init/delta) from the source ODS to the target ODS just by right-click on the ODS and saying "Update ODS data in DataTarget"...