ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Datastage sg July-20

Datastage sg July-20

原创 Linux操作系统 作者:kinglin_zy 时间:2011-07-20 18:04:26 0 删除 编辑

 

1         Data Stage Job Parameters

Below are the lists of common parameters that will be defined for the each job. Any additional requirement will be handled in the job itself.

 

SL NO

Parameter Name

Prompt

Data Type

Remarks

1

V_DATA_DIR

Source data directory.

String

 

2

V_SCHEMA_DIR

Schema file directory

String

 

3

S_CNTRY_CDE

Country Code.

String

 

4

V_FILE_NAME

Source File Name/TBL Name

String

 

5

V_TABLE_NAME

Target Table Name

String

 

5

V_MISDATE

Business Date.

String

The Format is YYYYMMDD

6

V_SRC_DIR

Source File ETL Input directory

String

 

7

I_READERS

Number of Readers per Node

Integer

 

8

V_DATASET_DIR

Dataset Directory

String

 

9

V_ORACL_SID

Oracle Server ID

String

 

10

V_ORACL_UID

Oracle User ID

String

 

11

V_ORACL_PWD

Oracle Password

Encrypted

 

12

V_LOG_DIR

Log Directory

String

 

13

V_FREQ

Data Load Frequency

String

 

14

V_TGT_CCY

Target Currency Code

String

 

15

V_LCL_CCY

Local Currency Code

String

 

16

V_SUBSYS

Subsystem or System Name

String

 

17

$APT_CONFIG_FILE

Data Stage Configuration File Name

String

This is required since the same job will run for other countries which may be of less data or more.

 

 

 

 

 

 

表的结构定义在schema file中

 

You can import a table definition from a data source via the Designer. You can also edit and define new table definitions in the Designer。

If you want, you can edit individual column definitions once you have loaded them into your stage.

 

1.1       Oracle Bulk Load

DataStage Job will get aborted when using Oracle Direct Load with Parallel option to an oracle table which have Partition and Local Indexes. To overcome this situation, a work around is follows:

Load the data to a dummy table which is of the same structure as of the original table.  Bulk load the data into the dummy table and move the data to the original table using exchange partition command of Oracle. While doing this, the index existing on the Partition will get unusable, so need to enable the Indexes also. The Oracle command for moving the table space is “ALTER TABLE   EXCHANGE PARTITION   WITH TABLE   WITHOUT VALIDATION;” and Enabling the indexes use “ALTER TABLE

  MODIFY PARTITION   REBUILD UNUSABLE LOCAL INDEXES;”

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/781883/viewspace-702682/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Basic datastage design
请登录后发表评论 登录
全部评论

注册时间:2009-09-22

  • 博文量
    58
  • 访问量
    67427