Open Access Open Access  Restricted Access Subscription or Fee Access

Data Staging under Supply Planning Landscape

R Vijaya Arjunan, Ramya Ramya, B. Kishore


Supply planning is an integral part of any manufacturing company. The fundamental need of having a supply planning framework arises from various issues during the procurement of goods. A proper framework is always required to ascertain exact quantity of goods emanating from one end to the other end. In order to handle data coming from multiple resources and to create a home for all, Data Staging (DS) is one of the finest approaches. The primary aim of DS is to develop a home for data thus manifesting a controlled and monitored flow of data along a supply chain. Besides, DS maintains the shared data across the network. As planning processes became more integrated and more sophisticated, common data models to support integration and databases to manage the planning data and integrate among systems became necessary. The data when comes from one source and it is processed and sent to the target, is used ultimately to decide what quantities of goods are going to be manufactured or shipped. These quantities are known as schedules which indicate the future volume to be produced by a factory and represent the build plan at a given point of observation in time. Actual subject area deals with bringing in lot level transactions from the source for different factories aligned with the respective factory cut off times. Actual quantities of items produced for each manufacturing stage are calculated based on the lot movement from one operation to another operation and rolled up to  work week based on the factory cut off time that are stored in the core table. Future scenario will be capturing the quantities of items produced for each manufacturing stage from various external locations. The maintenance issue rests with the DS and it also takes care of sharing data along the network so the sync issue is resolved by the functionality provided. Using this feature one can enable the user to maintain data quality as there is an automatic and early detection of data inconsistencies and there is a comprehensive proactive resolution to be applied to get the data fixed. Teradata Master Data Management Studio (Teradata MDM) tool is used to develop the staging systems.


Data Staging, Master Data Management, Teradata Master Data Management Studio, Data Mining

Full Text:



“Introduction to Teradata Warehouse”, Release V2R6.2 (Teradata Database)/ Release 8.2 (Teradata Warehouse).

Vassiliadis, P. and Simitsis, A., “Extraction, transformation, and loading”, Springer link, encyclopedia of database systems 2009, Part 5, pp. 1095-1101.

Gawande, S., “DS table/ Area Design”, ETL Guru, 11 October, 2006, pp. 2-3.

“Teradata application utilities and Intel Enterprise Data Warehouse (EDW) Extract Transform Load (ETL) methodology”, version 3.0 September 7, 2007, pp.137-159.

Vassiliadis, P., A survey of extract-transform-load technology. IJDWM. v5 i3. 1-27.

Luján-Mora, S., Vassiliadis, P. and Trujillo, J., Data mapping diagrams for data warehouse design with UML. In: Atzeni, P., Chu, W.W., Lu, H., Zhou, S., Ling, T.W. (Eds.), Lecture Notes in Computer Science, Vol. 3288. Springer. pp. 191-204.

Clarkston, “Supply Chain Management Primer”, 2000.

Bardano, R., “Introduction to Teradata: a student’s guide” version 1.0, 2003, Teradata customer education training centre.

SCOR, “Supply chain operations reference model”, Version 8.0, 2006, Supply chain council USA.

Oracle database data warehousing guide 11g release 1 (11.1), in: Tech -nical Report, available at portal_db?selected=6, Oracle.

Albrecht, A. and Naumann, F., Managing ETL processes. In: NTII, pp. 12-15.

Vassiliadis, P., Karagiannis, A., Tziovara, V. and Simitsis, A., Towards a benchmark for ETL workflows. In: Ganti, V., Naumann, F. (Eds.), QDB, pp. 49-60., Scrum organization, “Agile data warehousing”, website.


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.