Skip to main content
Hey, I am looking for a way to load the tables inside a DataJob in a specific order. Do you know any solutions?

Hi,

 

Can you provide more details, on what do you mean by 'Loading the tables', and what should be the outcome? I'm asking because tables are created/deleted and the DM is the only thing that can be loaded.

 

You can:

A) Decide in which order tables will be extracted from source system

B) Decide in which order DataJob will be executed (you can create artificial table there, thus deciding on creation order).

C) You can trigger DataModel load with all tables added to data model load - you cannot decide on order here. The only other option is to create 2 data model loads 1st will load everything but table A, second will only load table A. That way you can try to postpone some tables to be updated later, but I'm not sure for what purpose it could be useful.

 

Best Regards,

Mateusz Dudel


Hi Mateusz,

Thank you for your response. We encountered a problem where one particular table from the source system was fundamental to many others. Consequently, there were several joins on this table that underperformed because smaller tables were extracted first, leading to joins not being executed on the latest data.

We resolved this issue in the exact manner you outlined in option "C".

 

However, it might be significantly simpler if there was an option to directly set the extraction order somewhere.

 

Best Regards,

 

Felix


Reply