topic Re: tMysqlSCD & Update Type 1 & 2 in Talend Studio

tMysqlSCD & Update Type 1 & 2

Anonymous — Mon, 12 Mar 2018 08:59:55 GMT

Hi,

I have issue when I Use tMysqlScd with type 1 & 2 columns.

Exemple :

Sur Key	BusKey	City (Type 1)	Mail (type 2)		Flag
1	adam	NY	adam@telco.com		1

If I had new line with change with City & Mail, the information "NY" is lost.

The result I expected was

Therefore, if i Had new line, all type 1 were updated like a Type 6

manodwhb — Tue, 13 Mar 2018 05:40:09 GMT

can you show the tMysqlScd configuration?

dasari16 — Tue, 13 Mar 2018 11:24:28 GMT

Based on your Inputs, I just designed a job and attached the screen shots. Kindly refer and let me know if that helps you to move fwd.

Anonymous — Tue, 13 Mar 2018 17:59:31 GMT

Tks dasari16

You use City as Type 2, in my case City is Type 1.

To explain more my case

Sur Key	BusKey	City (Type 1)	Mail (type 2)		Flag
1	adam	NY	adam@telco.com		1

If I had new line with change only with City (NY to SA) I expected only update

Sur Key	BusKey	City (Type 1)	Mail (type 2)	Flag
1	adam	SA	adam@telco.com	1

If I had change in City AND Mail, I expected only update on FLAG, start_date for last row and new values for new rows

manodwhb — Wed, 14 Mar 2018 04:46:06 GMT

if you use City as type1,then you will always have latest city.you may need to change city to type2.

manodwhb — Tue, 03 Apr 2018 14:18:14 GMT

@pierre,did it help you?

Anonymous — Tue, 03 Apr 2018 14:50:04 GMT

Tks but SCD doen't match with my specific case.

I develop complementary process to do what I want.