DSXchange

Code: Select all

Table of Contents

Job Properties
Source Stages
T1
Processing Stages
T2
CLONE_STG_FAC_TABLES
Target Stages
CLONE_STATUS


Job Properties

Category:	SHARED\CLONE_STG_FAC_TABLES
Job version number:	50.0.0
Runtime column propagation:	Enabled
Allow multiple invocations:	Yes
NLS Locale:	Time=(Project default) Numeric=(Project default) Currency=(Project default) CType=(Project default) Collate=(Project default)
Parameters

Parameter Name	Default Value
$STG_CPM_USER	$PROJDEF
$STG_CPM_PSWD	********
$DB_CPM_NAME	$PROJDEF
$QRY_CPM_PSWD	********
$PROJECT	$PROJDEF
$QRY_CPM_USER	$PROJDEF
SRC_TABLE	
TRG_TABLE	
Source Stages

Transformer : T1
Stage variable: PROD


Derivation: 1
Output: LinkToCLONE_STG_FAC_TABLES

Outputs to Stored Procedure stage CLONE_STG_FAC_TABLES
Constraint:	@OUTROWNUM=1
Derived Columns

SRC_TABLE	SRC_TABLE
TRG_TABLE	TRG_TABLE
Pass-through Columns

Processing Stages

Transformer : T2
Input: LinkFromCLONE_STG_FAC_TABLES

Input from Stored Procedure stage CLONE_STG_FAC_TABLES
Output: LinkToCLONE_STATUS

Outputs to Sequential File stage CLONE_STATUS
Constraint:	
Derived Columns

Pass-through Columns

ProcCode	 from link LinkFromCLONE_STG_FAC_TABLES
ProcMess	 from link LinkFromCLONE_STG_FAC_TABLES
STATUS	 from link LinkFromCLONE_STG_FAC_TABLES
Stored Procedure : CLONE_STG_FAC_TABLES
Database Vendor:	Oracle
Data Source Name:	#$DB_CPM_NAME#
User Name:	#$QRY_CPM_USER#
Password:	********
Database name:	#$DB_CPM_NAME#
Stored Procedure Name:	CLONE_STG_FAC_TABLES_OLD
Generate Procedure Call:	Yes
Procedure Type:	Transform
Stored Procedure Statement:	BEGIN CLONE_STG_FAC_TABLES_OLD(:1); END;
Stored Procedure Parameters:	SRC_TABLE-+-SRC_TABLE-+-?-+-I+-+TARGET_TABLE-+-TRG_TABLE-+-?-+-I+-+STATUS-+-STATUS-+-?-+-O
Transaction isolation level:	None
Input: LinkToCLONE_STG_FAC_TABLES

Input from Transformer stage T1
Forward Row Data:	No
Rows per transaction:	0
Execute Procedure For Each Row:	Yes
Output: LinkFromCLONE_STG_FAC_TABLES

Outputs to Transformer stage T2
Procedure Return Code:	Yes
Return Multiple Rows:	No
Output Columns

ProcCode	Integer(10)
ProcMess	VarChar(128)
STATUS	VarChar(30)
Target Stages

Sequential File : CLONE_STATUS
Line termination:	DOS
Stage uses named pipes:	File
First character is Byte Order Mark:	Yes
Use UNICODE map:	Yes
Allow per-column mapping:	No
Stage uses filter commands:	No
Input: LinkToCLONE_STATUS

Input from Transformer stage T2
File name:	F:\ETL\#$PROJECT#\TEMP\#TRG_TABLE#_CLONE_STATUS.TXT
Delimiter:	,
Quote character:	"
First line is column names:	Yes
Omit last new-line:	No
Append to existing file:	No
Backup existing file:	No
Fixed-width columns:	No
Spaces between columns:	0
Missing columns action:	0
Write timeout:	0
Wait for reader timeout:	0
Default padding:	#

Code: Select all

From previous run
DataStage Job 6125 Phantom 7176
Program "DSD.ParseTextProp": Line 92, Exception raised in GCI subroutine:
Access violation.

From previous run
DataStage Job 6125 Phantom 9256
Program "DSD.ParseTextProp": Line 92, Exception raised in GCI subroutine:
Access violation.

From previous run
DataStage Job 6125 Phantom 7176
Program "DSD.ParseTextProp": Line 92, Exception raised in GCI subroutine:
Access violation.

From previous run
DataStage Job 6125 Phantom 6600
Program "DSD.LinkReport": Line 68, Exception raised in GCI subroutine:
Access violation.