White Papers

Parameter Driven Data Integration Using SAS Stored Processes

Category: Data Management, Networking and Communications

Tags: data integration, data warehouse, data

Overview The data warehouse at this large, metropolitan, state university consists of term and annual census data. Loading data into the warehouse is a Data Integration (DI) process that cannot be scheduled to run at a particular time each day as it requires human intervention to specify the appropriate time period for the new data. The data transforms in the process flow could be changed each term or year, but each node that requires this term parameter would need to be changed. The paper desired a DI process that would prompt the data integration developer to provide this input when the job is executed and it would remain constant throughout the process flow.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: SAS Institute
File Format: PDF
Date Published: May 29, 2009
Format: White Papers
Topics: Business Intelligence - Data Warehousing, Voice - Data Integration

Similiar White Papers

Data Warehouse Vs. Data Mart - Approaches to Implementing a Data Integration Solution

The goal of this white paper series is to outline some basic approaches to implementing data integration solutions. This

Publisher: Elite Management Consulting | Tags: business intelligence, data, data integration, data management, management, warehouse

Nestle Nespresso S.A. Provides Its Decision-Makers With High-Value-Added Actionable Data

Nestle Nespresso S.A wanted to enable the marketing and Customer Relationship Management (CRM) team to undertake client

Publisher: Oracle | Tags: crm, data, data warehouse, database, marketing

Life Cycle of SAS Intelligence Platform Project

This paper provides an overview of the SAS 9 Intelligence Platform and the steps to be followed from setting up of this

Publisher: SAS Institute | Tags: bi, project manager, server

EAI Vs. ETL: Drawing Boundaries for Data Integration

Business enterprises invest millions of dollars to implement and deliver Data Warehousing and Business Intelligence (BI)

Publisher: Syntel | Tags: bi, data, data integration

State of the Data Integration Market

Data integration is a critical and fundamental element in a variety of technologies, including data warehouses, business

Publisher: Oracle | Tags: applications, bi, business intelligence, data, data integration, data management, management, mdm, soa

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute | Tags: crm, customer service, data, data mining

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »