Hi All, I have a process that reads a sequential file using RCP and a schema file. The rows are then sent to Teradata to do an upsert. The issue is that the Teradata stage does not know what the Key is when doing an update. I researched to determine if I can set a column in a schema file as the key but doesn't look like it's possible. Basically I want to set the key property of a column in the schema file to Y somewhere before the Teradata Stage. Can I use the Modify stage to set a column as the key
Job Design
Seqential File ---->Teradata
Thanks in advance
Setting Column as Key Dynamically
Moderators: chulett, rschirm, roy
Have a look at this post.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon