ODS to ODS load returns 0 records

[Former Member]

Hello all,

I created an ODS 1 and loaded some data via flatfile. From ODS1 i want to update the data to ODS 2. for this i created update rules between 2 ods and create an export data source on ODS1.

ODS 1 settings are set to update QM status automatically and activate ODS data automatically.

But, when i execute info package to load data from ODS 1 to ODS 2, it returns 0 records. ODS1 contains some records already. I even tried to load data only to PSA first. but still it returns 0 records. Why ????

Where else i need to check.

Thanks in advacne

POPS

[Former Member · Accepted solution]

Hi

If there is data already present in ODS1 then cross check your Update Rules again see if all the fields are mapped properly and are the update rules active or not if not then activate ur update rule first and then try loading data to ODS2.

it is not necessary that the fields should b common but atleast the fields should have same data type or the field in the ODS 2 should have length bigger to the field in ods1. coz if the fields are not relevant the systm wont allow u to map them

hope it is helpful assign points if applicable

Thanks

puneet

[Former Member · Accepted solution]

Thanks Punnet,

The Update rules are already active.. Now i am checking the mappings between ODS1 and ODS2.

Cheers

[Former Member · Accepted solution]

Hi

in case u find that a field is not mapped go to the source ODS and see if there is a relevant field that can be mapped and u find that there is a filed but it is not shown while creating update rules then there is mismatch betwn the datatypes of the fields also cross check all the key fields m sure the char wud have been mapped corectly but one or the other keyfields are left unmapped. map all the keyfilelds too and then activate the Update rule and load data

hope it is helpful

thanks

puneet

[Former Member · Accepted solution]

Hi Puneet,

In the update rules, i am using constants to map some keyfields. and 2 fields are blank. everythings looks fine to me. But when i try to load data from ODS 1 to ODS 2 it gives 0 records.

any ideas ????

[Former Member · Accepted solution]

are these the fields keyfields or the char which are blank if keyfields then there shud be something to map to it and what strikes into my mind is the constants mite b the problm

key field mapping means

select field 1, field 2

from lets say ods1

where kf1(ods1) = kf2(ods2)

when there will be mapping betwn kf1(key field 1) and kf(2) keyfield 2 then only i guess u wil get data for field 1 and field 2 which are ur char

hope u understand the concept m tryin to tell u

thanks

puneet

[Former Member · Accepted solution]

Are you Using BI or BW.

In case of BI it wud be better if you could try loading using Delta instead of Full. I came across the same issue a while back, but my scenario was a bit different.

In case I would like to recommend to create an idential DSO object (ODS) to the ODS1 and see if data is being transferred if both of the DSOs are identical in all aspects.

Let us know what happens.

Good Luck,

Raj

[Former Member · Accepted solution]

Hi

Oscar,

I m doing a full update from ODS1 to ODS2.

Raj,

I am on BW 3.1c. But any way I will try to do init first and then do the delta.

Thanks

POPS

[Former Member · Accepted solution]

Hi Raj,

Your theory worked perfectly in my scenario as well. ( BW3.1c)

I did the init with data transfer followed by delta.

But still I am not able to understand why the full load did not bring any records to ODS2.

Cheers

POPS

[Former Member · Accepted solution]

Hi POPS,

Well it happens so that you might have tried doing a full update first and didn't clear the PSA , it happens so that if PSA has data then full upload doesnt bring any records. This is what I observed. Thats why when trying to extract data in ODS1 I do a full upload and from ODS1 to ODS2 I do init./Delta.This way I dont have to worry abt the PSA or internal tables.

Happy to see it work.

Raj

[Former Member]

Did you initialize for the first load?

Regards

[Former Member]

Furthur update on this,

I noticed that there are no common info objects used in ODS 1 and ODS 2. Does this make any sense ?? do we need to have any common key fields used in both the ODS's.