Staging Table / Atomic Table ???

[murali_v_s]

Hi,

One quick question. What is the difference between Staging Tables and Atomic Tables ?

I am under the impression that atomic tables are the logical schema objects wherein we store data.

I really am not clear on staging tables.

Can somebody clarify ??

Murali

[tamilselvan]

Those terms are used in Data Warehouse System.

A "Staging table" is a temporary table used by ETL.

A "Atomic Table" or "Fact Table" is used to store detailed information about a business process at the lowest level (for example order line item).

[murali_v_s]

Thanks Tamil.

I learned something today.

Murali