LO data source Extraction

[Former Member]

Hi Expert,

2lis_11_vahdr data source data loading perfect in production server, But user need one more field which is in HIDE in ECC dats source structure.

UN HIDING ok but alternative way for loading data for that field in production other than full load.

for below hide field un hide in ECC server and replicated to BW and mapped. NOW data loading is procedure is normal. I need to know best way to do un hide and data loading instead of full load. Please advise me....

Thanks & Regards,

Srinu.Rapolu

[RamanKorrapati · Accepted solution]

Hi,

Assuming as you need historic data for un-hide field.

There is no option to fill particular field only.

So we need to drop and reload the whole data.

in case of LO, we need to delete and refill set up tables.

Another way:

Assuming as Hiden field was exist in bw side in dso or master data.

Assuming as you have dso in your data flow.

All key fig over write function.

In such case you can create self transformations to dso and fill un-hide field thru look up.

From DSO to further targets, you may need delete and reload the whole data.

Thanks

[Former Member · Accepted solution]

Any more information on this.

Thanks & Regards,

Srinu.Rapolu

[RamanKorrapati · Accepted solution]

Hi,

There is no other alternative.

if need historic data for un-hide field then delete and reload is mandatory.

Thanks

Raman

[Former Member · Accepted solution]

Hi All,

for the above loading issue, shell I use the early delta initialization. Suggest me on this.

Thanks & Regards,

Srinu.Rapolu

[RamanKorrapati · Accepted solution]

Hi

Not useful.

Early delta -  Purpose - Without down time we can  load the data into bw. Even we won't miss the data which was entering at that time.

in case of lo early delta also not useful. it may leads duplication data.

So locking source system and reload is the only way.

But your case is not that way, You need historic data, Drop and reload is mandatory.

Even rather than asking here, Can you check with your team.

When doing such activity, TL or senior consultant may propose check-list or following actions.

Thanks.

[KodandaPani_KV]

Hi,

if you want full load for the specific field you need to drop and run the full info package again.

it is not possible to load the data for the specific field.

Thanks,

Phani.