topic Re: Issue with tMysqlscd Component in Talend Studio

Issue with tMysqlscd Component

Bhagwati1 — Wed, 02 Aug 2017 06:34:34 GMT

Hello Guys,

I am trying to implement SCD type 2 using tMysqlSCD.Below are the screenshots of my Job.

Below are primary Keys in Source table.

1.Rec_source

2.Rec_Date

3.Fund_ID

Below are primary Keys in Destination table.

1.Rec_source

2.Rec_Date

3.Fund_ID

4.Trans_ID

Issue Description :

Scd_end,scd_version and scd_active do change when a there are changes for non-primary key field.(part of SCD type 2 field).

I am not sure if i am missing something.

Could you please help?

Thanks

Bhagwati

Re: Issue with tMysqlscd Component

Anonymous — Wed, 02 Aug 2017 06:51:57 GMT

Hi
Uncheck the 'key' box of Trans_ID column on the schema, this field is the surrogate key.

Regards
Shong

Re: Issue with tMysqlscd Component

Bhagwati1 — Thu, 03 Aug 2017 22:40:18 GMT

Thanks for your respone !

I tried your suggestion but unfortunately it is not working. I am using talend 6.1 Open studio.

Could you please advise?

Thanks,

Bhagwati

Re: Issue with tMysqlscd Component

Bhagwati1 — Tue, 08 Aug 2017 06:17:39 GMT

Hello,

Another finding,

tMySqlSCD works when data is loaded from Excel to Mysql table.

But fails when i load data from MySQL table to another MySQL table. Not sure if i am missing something.

Anyone please help?

Thanks,

Bhagwati

Re: Issue with tMysqlscd Component

Anonymous — Wed, 09 Aug 2017 06:33:18 GMT

Hi
Print the data on the console to see what's the difference between Excel's data and DB data. In addition, you use a tMysqlConnection to create the db connection, you should use also a tMysqlCommit to commit the changes if the job works fine and tMysqlRollback if the to rollback the changes if the job fails.

Regards
Shong