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
DataBase Stage
Moderators: chulett, rschirm, roy
Re: DataBase Stage
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,
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,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.