-
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
-
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).
-
Thanks Tamil.
I learned something today.
Murali
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|