I am trying to create a job that reads in a dataset and creates/replaces a target table on Teradata based on the input dataset. I am usingthe Teradata Connector, but cannot find a place to specify the primary index. In the TD Enterprise stage, there was an option for this. Is there a comparable option in the TD Connector? I haven't been able to find one yet.
My concern about doing this without having control over the primary index is that I believe DataStage will opt to use the first field of the dataset as the PI. In many cases, this is not the optimal field for evenly hashing your data. I don't want to end up with skewed tables on the database. It is a waste of space and slows down processing, too.
Let me know. Thanks!
Brad.
How to specify a primary index on a table create in Teradata
Moderators: chulett, rschirm, roy
How to specify a primary index on a table create in Teradata
It is not that I am addicted to coffee, it's just that I need it to survive.