I want to understand the use of this feature?

apurva1310
apurva1310
in Modeling
image.png
image.png

I am trying to import data from Data Hub to spoke model. The requirement is to clear the target before loading the new data. Can I use this option at 'All Items' as an alternative to creating clear module data actions using 'No data' formatted clear line items in the target? Is that more efficient? Does it work the same way as clear action? I see this option for every dimension, and I am planning to enable it for data imports.

Tagged:

Best Answer

  • TristanS
    TristanS
    edited September 2023 Answer ✓

    @Apurva Raspayle yes it will work as per your understanding. So for example, your target has list items below:

    • A
    • B
    • C

    But your import only has list items

    • A
    • B

    Setting it all items will clear A, B and C regardless whether your import has the target list item or not

    Note you may have to set the option to All Items for the line items as well

Categories