Home > ETL Best Practices > A Sample Staging tables volumetric worksheet

A Sample Staging tables volumetric worksheet

A sample table volumetric worksheet from the ETL Toolkit focusing on the final delivery tables at the end of the ETL data flow.

A full volumetric tracking system would have similar worksheets for copies of source data and the staging files that followed the cleaning and conforming steps.

image

The volumetric worksheet lists each table in the staging area with the
following information:

image

image

image

The staging area normally consists of both DBMS tables and flat text files on the file system. Can we use flat files for staging. Yes. Flat files are especially important when using a dedicated ETL tool. Most of the tools utilize an area in the file system for placing data down to optimize its workflow. In many cases, you need to stage your data outside of a DBMS in flat files for fast sequential processing. You can also use the volumetric
worksheet for file-system planning.

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: