Category
Data Transformation
Product Version
7.4
Output To Insert Table with Serial Primary Key
Answered
Is it possible to output the transformation flows to a table with serial primary key?
The same question
Hi Stephanus,
It is possible to set primary keys in the output step when creating new tables, but there is currently no function to make automatically include a serial primary key. You could use something like the R step to create this manually, or code your own step in Java (though the documentation is not currently ready for this).
Alternatively we could put together an auto increment step for this use case, which would be a pretty quick process but would fall more under paid services.
Let me know your thoughts.
Regards,
Nathan
Hi Stephanus,
It is possible to set primary keys in the output step when creating new tables, but there is currently no function to make automatically include a serial primary key. You could use something like the R step to create this manually, or code your own step in Java (though the documentation is not currently ready for this).
Alternatively we could put together an auto increment step for this use case, which would be a pretty quick process but would fall more under paid services.
Let me know your thoughts.
Regards,
Nathan
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Replies have been locked on this page!