Write Default Row to Dimension Table
Posted: Wed Nov 12, 2003 2:18 pm
I am using DataStage 5.2 on Win2000
I need to write a default row to a hash table before I load in the operational data. The target has two columns - Code and Description.
I selected a transform stage and a hash stage as output. I put the constants into the derivation areas in the transform stage. Code =9 and Description=UNKNOWN.
Everything compiles great, but when executed the job just keeps running.
Why doesn't it just put in one row?
What is the easiest way to put one default row into a target hash or target Oracle table?
Daniel A. Sutton Associate Technical Fellow, Boeing Navigator
Hierarchical Databases, Data Warehouse, and Migration Control Group
To be in a dialogue, we must listen from where the other person speaks.
Otherwise, we only have two monologues
Boeing Philadelphia IS/Data Management
610-591-7124 610-591-7524(fax) 800-946-4646 pwd 1499533(beeper)
email: daniel.a.sutton@boeing.com
Regular Mail Address:
Boeing
PO Box 16858 MS-P29-29
Philadelphia PA 19142-0858
I need to write a default row to a hash table before I load in the operational data. The target has two columns - Code and Description.
I selected a transform stage and a hash stage as output. I put the constants into the derivation areas in the transform stage. Code =9 and Description=UNKNOWN.
Everything compiles great, but when executed the job just keeps running.
Why doesn't it just put in one row?
What is the easiest way to put one default row into a target hash or target Oracle table?
Daniel A. Sutton Associate Technical Fellow, Boeing Navigator
Hierarchical Databases, Data Warehouse, and Migration Control Group
To be in a dialogue, we must listen from where the other person speaks.
Otherwise, we only have two monologues
Boeing Philadelphia IS/Data Management
610-591-7124 610-591-7524(fax) 800-946-4646 pwd 1499533(beeper)
email: daniel.a.sutton@boeing.com
Regular Mail Address:
Boeing
PO Box 16858 MS-P29-29
Philadelphia PA 19142-0858