Use both Full & Delta from different source to DSO

[former_member646598]

Dear Expert,

I had designed DSO A as a Copy from DSO B and have 2 transformations. The first transformation is from DSO B for full load past data ( data 2020) and the second transformation is from data source 2LIS_02_ITM to load delta (from January - now). DSO B has a transformation from 2LIS_02_ITM too, and still loads data from data source 2LIS_02_ITM until now.

My question is if I create a transformation from DSO A to a cube with delta, Is the delta still work? Because there is 2 way of populating data in DSO A (full & delta) even both come from a different source.

Thanks,

Jo

[sgassem · Accepted solution]

That is correct. You only need a delta DTP. You don't want to do a full load to the cube each time.

The first time you run the DTP, it will do an init full and thereafter will be delta.

[sgassem]

You sure can have multiple sources to a cube. The first load from DSO A and DSO B to the cube will be "init" load and thereafter will be delta.

[former_member646598]

Hi Sam,

Thanks for answering. So It means I can only use delta DTP from DSO A to Cube? Because I already get a full load from DSO B to DSO A for last year's data and delta load from the data source to DSO A for current year. Am I right?