DataBase Stage

[sachinag]

Hi Team,

I am using teradata connector stage in my job.The column sequence in my user defined query in like ColumnA, ColumnB, ColumnC.

But while defining the column sequence in column tab of connector stage the sequence in differ like columnB,columnC,ColumnA

My job is running successfully,the data is also properly populating & I am not using any alias in the query.

Please help me on this....It is right or some bug is there because as per my knowledge my job should abort if the column sequence is not same as in the query.

Regards,
Sachin Gupta

[jwiles]

Sachin,

There is no problem with this. The sequence of the columns in the columns tab is arbitrary and doesn't affect how the jobs work. Typically the only stages where it may make a difference are sequential file, fileset, external source, external target and external filter.

Regards,