Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

PT070_Performance_Test_Database_Load_Program_Designs

VIEWS: 7 PAGES: 7

									AIM

PT.070 PERFORMANCE TEST DATABASE LOAD PROGRAM DESIGNS <Company Long Name> <Subject>

Author: Creation Date: Last Updated: Document Ref: Version:

<Author> May 19, 1999 August 21, 2009 <Document Reference Number> DRAFT 1A

Approvals: <Approver 1> <Approver 2>

Copy Number

_____

PT.070 Performance Test Database Load Program Designs

Doc Ref: <Document Reference Number> XXX 0, 0000

Document Control
Change Record
3

Date 19-May-99

Author <Author>

Version Draft 1a

Change Reference No Previous Document

Reviewers

Name

Position

Distribution

Copy No. 1 2 3 4

Name Library Master

Location Project Library Project Manager

Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

<Subject> File Ref: 81c5cf25-87d8-42c4-9835-cfa4866fdcf9.doc (v. DRAFT 1A ) Company Confidential - For internal use only

Document Control

ii

PT.070 Performance Test Database Load Program Designs

Doc Ref: <Document Reference Number> XXX 0, 0000

Contents

Document Control .................................................................................................................. ii Introduction ............................................................................................................................. 1 Purpose.............................................................................................................................. 1 Scope and Application .................................................................................................... 1 Application Setup Data Load Programs .............................................................................. 2 <Setup Business Object> ................................................................................................. 2 Application Transaction Data Load Programs ................................................................... 3 <Transaction Business Object> ...................................................................................... 3 Open and Closed Issues for this Deliverable ...................................................................... 4 Open Issues ....................................................................................................................... 4 Closed Issues .................................................................................................................... 4

<Subject> File Ref: 81c5cf25-87d8-42c4-9835-cfa4866fdcf9.doc (v. DRAFT 1A ) Company Confidential - For internal use only

Document Control

iii

PT.070 Performance Test Database Load Program Designs

Doc Ref: <Document Reference Number> XXX 0, 0000

Introduction
Purpose
The purpose of the Test Data Load Program Designs document is to specify the designs for any special test data load programs. These programs are for the population of the performance test database, and data they populate is not available from other project activities in the <Project Name> project.

Scope and Application
Test design of the database load programs will accomplish automated loading of extra volumes of artificially manufactured data for the following business objects: Setup Data  Inventory Items   Transaction Data  Sales Orders  

<Subject> File Ref: 81c5cf25-87d8-42c4-9835-cfa4866fdcf9.doc (v. DRAFT 1A ) Company Confidential - For internal use only

Introduction

1 of 4

PT.070 Performance Test Database Load Program Designs

Doc Ref: <Document Reference Number> XXX 0, 0000

Application Setup Data Load Programs
<Setup Business Object>
Approach <Describe the general approach to use in loading this setup business object> Target Tables The following tables need population in Oracle Applications for the automated load of <Setup Business Object>:    The following criteria facilitated preparation of this list of tables ... The main foreign key relationships are:  <Table 1>: FK 1, FK2,...  <Table 2>: FK1, FK2,... Load Program Pseudo-Code BEGIN END Data selection SELECT FROM WHERE AND Data Mapping <data> <tables> <select criteria> <join conditions>

Table <table name>

Column <column name> <column 2> <column 3>

Source Value <table>.<column> 'Literal string' (Description of derived value)

<Subject> Application Setup Data Load Programs File Ref: 81c5cf25-87d8-42c4-9835-cfa4866fdcf9.doc (v. DRAFT 1A ) Company Confidential - For internal use only

2 of 4

PT.070 Performance Test Database Load Program Designs

Doc Ref: <Document Reference Number> XXX 0, 0000

Application Transaction Data Load Programs
<Transaction Business Object>
Approach <Describe the general approach to use in loading this transaction business object> Data Model The following tables need population in Oracle Applications for the automated load of <Transaction Business Object>:    The following criteria facilitated this list of tables ... The main foreign key relationships are:  <Table 1>: FK 1, FK2,...  <Table 2>: FK1, FK2,... Load Program Pseudo-Code

BEGIN END Data Selection

SELECT FROM WHERE AND Data Mapping

<data> <tables> <select criteria> <join conditions>

Table <table name>

Column <column name> <column 2> <column 3>

Source Value <table>.<column> 'Literal string' (Description of derived value)

<Subject> Application Transaction Data Load Programs File Ref: 81c5cf25-87d8-42c4-9835-cfa4866fdcf9.doc (v. DRAFT 1A ) Company Confidential - For internal use only

3 of 4

PT.070 Performance Test Database Load Program Designs

Doc Ref: <Document Reference Number> XXX 0, 0000

Open and Closed Issues for this Deliverable
Open Issues

ID

Issue

Resolution

Responsibility

Target Date

Impact Date

Closed Issues

ID

Issue

Resolution

Responsibility

Target Date

Impact Date

<Subject> Open and Closed Issues for this Deliverable File Ref: 81c5cf25-87d8-42c4-9835-cfa4866fdcf9.doc (v. DRAFT 1A ) Company Confidential - For internal use only

4 of 4


								
To top