Problems with QualityStage metadata on the server.
Posted: Thu Nov 06, 2003 2:16 am
I'm having a problem with the import of metadata from QualityStage into DataStage. When I change a data file definition that has already been imported into DataStage I am unable to update the DataStage definition.
For example if I import a table from QualityStage into DataStage:
I deploy a QualityStage job using this file and then import it into DataStage via the Metadata import. I then change the length of one of the fields in QualityStage and deploy the job again:
I import it again into DataStage via metadata import. It brings the ACCTNO in as 12, it is unable to recognise that the column length has changed to 20. If I set the column in DataStage to 20 manually then the job fails reporting that the column:
Link column 'ACCTNO' length mismatch in link 'q1'
The only way I've been able to successfully move a column change from QualityStage to DataStage is by renaming the data file whenever a change is made. Then DataStage imports the correct columns. This is creating havoc with our naming conventions. Does anyone know where DataStage is pulling the old column definition from? It has been updated in the local repository, it has been updated on the server in the DIC directory yet DataStage is still finding an old definition somewhere.
For example if I import a table from QualityStage into DataStage:
Code: Select all
FieldName Length Start
CUSTID 12 1
ACCTNO 12 13
Code: Select all
FieldName Length Start
CUSTID 12 1
ACCTNO 20 13
Link column 'ACCTNO' length mismatch in link 'q1'
The only way I've been able to successfully move a column change from QualityStage to DataStage is by renaming the data file whenever a change is made. Then DataStage imports the correct columns. This is creating havoc with our naming conventions. Does anyone know where DataStage is pulling the old column definition from? It has been updated in the local repository, it has been updated on the server in the DIC directory yet DataStage is still finding an old definition somewhere.