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