Dump load task: difference between "Load into SQL" and "Load into cube"
In the "Dump load task" package, there are the following options: "Load into SQL" and "Load into cube"
Can you explain the difference between these 2 ones? In which case you use one and not the other one?
thanks for your help,
Sorin Radulescu replied
Load into cube means that you are loading data into fac2 table and after that fac2 partition is process incremental.
Load into sql means that system insert records into wb table (ROLAP) partition and that's it.
If you have files for import with maximum 1000 records of course it is better to use Load into SQL.
If you have files which can be bigger than 40 000 records than it is better to use Load into cube.