Dataset schema is disordered
Posted: Thu May 27, 2010 7:15 pm
Hi Forum,
I'm using a virtual machine running Linux and my job is reading a
sequential file as bulk, one field defined as varchar (1000), and
parsing the fields with column import stage. The next stage is a
Transformer and finally write in a dataset.
The parsing convert the input field in 3 new fields, including the
original column (property Keep Import Column = Yes) and the transformer
complete the final structure (8 columns) with other functions
(string and numeric).
The final structure is:
OrderNum
RecType
Name
OrderDate
ProductID
Qty
RecordNum
RecIn
When i run the job is finished ok and i can view the dataset result
in the viewer, but when use the "Dataset Management" and shown the
schema, the fields are disordered
Name
OrderDate
ProductID
Qty
RecordNum
OrderNum
RecType
RecIn
this behavior is normal?? or there is an error in the dataset definition??
I'm using a virtual machine running Linux and my job is reading a
sequential file as bulk, one field defined as varchar (1000), and
parsing the fields with column import stage. The next stage is a
Transformer and finally write in a dataset.
The parsing convert the input field in 3 new fields, including the
original column (property Keep Import Column = Yes) and the transformer
complete the final structure (8 columns) with other functions
(string and numeric).
The final structure is:
OrderNum
RecType
Name
OrderDate
ProductID
Qty
RecordNum
RecIn
When i run the job is finished ok and i can view the dataset result
in the viewer, but when use the "Dataset Management" and shown the
schema, the fields are disordered
Name
OrderDate
ProductID
Qty
RecordNum
OrderNum
RecType
RecIn
this behavior is normal?? or there is an error in the dataset definition??