Creating Data Objects Overview
In the Analyst tool, a data object is a representation of data based on a flat file or relational database table. You create a flat file or table data object and then use the flat file and table data objects in a mapping specification.
Story
HypoStores keeps its customer data in flat files and relational tables. HypoStores needs to analyze the data and perform data integration tasks.
Objectives
In this lesson, you complete the following tasks:
- 1. Upload the flat files to the flat file cache location and create flat file data objects.
- 2. Import a target table data object into the Analyst tool.
- 3. Preview the data for the data objects.
Prerequisites
Before you start this lesson, verify the following prerequisites:
- •You have completed lesson 1 in this tutorial.
- •You have the Accounts.txt and Customers.txt flat files. You can download the Accounts.txt file here and the Customers.txt file here.
- •You have the Oracle client installed to create the Customer_Accounts target table data object.
- •You have the connection to the Oracle database.
- •You have the target.sql table. You can download the script here. Use Oracle SQL Plus to run SQL statements to create a target table.
Timing
Set aside 10 to 15 minutes to complete this lesson.