Data Staging

Data staging table / area design.

This could be long topic of discussion.  Following are the main issues I would like to discuss on staging table /database design. 1. Why staging area is needed? Unlike OLTP systems that create their own data through an user interface data warehouses source their data from other systems. There is physical data movement from source […]

Multiple executions ETL process against same set of data.

Every ETL designer, developer & tester should always ask this question…”What will happen, if I run the ETL process multiple times, against the same data set?” Answer: 1. I get the same result set. Answer: 2. I get multiple result set. If you go back to the original article on What is ETL & What […]