0

Possibility to partially load staging - datawarehouse ?

Joke Laukens

May 27, 2019 07:01

None

Follow

Hi,

Is it possible to partially load staging and the data warehouse? What would be the best practice in implementing it?

Thx.

 

• Facebook
• Twitter
• LinkedIn

9 comments

• 0
  
  Harry Lewis May 28, 2019 14:16

  Hello Joke -

  Incremental loading allows an organization to only load the most recent transactional data into their data warehouse and staging databases.  You can find information in Incremental Loading Configuration

   

• 0
  
  Joke Laukens May 28, 2019 14:30

  Hi Harry,

  Actually, I only want to process a part of the datawarehouse: a limited set of tables in stead of all tables.

  I do not want to process incrementally - that is not the answer I am looking for.

  Thanks,

  Joke.

• 0
  
  Harry Lewis May 28, 2019 14:51

  The Jet Data Manager User Guide contains all the documentation on using the Jet Data Manager and selecting those tables you want to include.

• 0
  
  Rob Fontaine May 29, 2019 15:56

  Hi Joke,

  You could maybe try guarding the tables that you do not want to execute.

  https://support.jetglobal.com/hc/en-us/articles/219400637-Guarding-Tables-and-Data-Sources

  Rob

• 0
  
  Joke Laukens May 31, 2019 11:30

  Hi,

  That will not help me, as I want everything to be processed during the night, but only a part of the datawarehouse during the day.

  Any suggestions?

  Thanks.

• 0
  
  Joke Laukens May 31, 2019 11:36

  Harry,

  Thanks for you response.
  Howerver, the link doesn't work. Could you send it again?

  Thanks.

• 0
  
  Harry Lewis May 31, 2019 13:57

  Here you go:  https://support.jetglobal.com/hc/en-us/articles/218951728

   

• 0
  
  Keith Chafin May 31, 2019 14:28

  Why don't you create an execution package including only  the tables you want to process during the day?  This will allow you to select exactly what you want to load and what to exclude.

• 0
  
  Joke Laukens June 03, 2019 06:37

  Hi,

  I'll try that.

  Thanks for the suggestions!

  KR,

  Joke.