Setting Column as Key Dynamically

[Azzuri]

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

[BI-RMA]

Have a look at this post.

[Azzuri]

Worked perfectly using Generic Stage. Thanks!