In this MySQL target, the surrogate key is an auto_increment field. This would be the same for MS SQL Server.
Oracle and Postgres uses a sequence (mysequence.NEXTVAL) to generate the surrogate key.
In Oracle's case, it's possible to first retrieve a sequence and then apply it to more than one target. When using an auto_incr field, you'll need to retrieve the key by a query in the same transation to apply it elsewhere.
Consider using a tMysqlOutput rather than a tMysqlRow .
In this MySQL target, the surrogate key is an auto_increment field. This would be the same for MS SQL Server.
Oracle and Postgres uses a sequence (mysequence.NEXTVAL) to generate the surrogate key.
In Oracle's case, it's possible to first retrieve a sequence and then apply it to more than one target. When using an auto_incr field, you'll need to retrieve the key by a query in the same transation to apply it elsewhere.
Consider using a tMysqlOutput rather than a tMysqlRow .
bekwam 2 months ago
hi, nice tutorial.but u didn't show how to generate surrogate key.
matelemahesh705 2 months ago
Be sure to check out bekwam.blogspot.com/2011/02/talend-open-studio-date-dimension-job.html for the date dimension
bekwam 1 year ago