tMysqlSCD & Update Type 1 & 2

[Anonymous]

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. 

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

The result I expected was

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

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

Sur Key	BusKey	City (Type 1)	Mail (type 2)	Flag
1	adam	LA	adam@telco.com	0
2	adam	LA	adam.sa@telco.com	0
3	adam	LA	adam.la@telco.com	1

[manodwhb]

can you show the tMysqlScd configuration?

[dasari16]

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]

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

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

[manodwhb]

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

[manodwhb]

@pierre,did it help you?

[Anonymous · Accepted solution]

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

I develop complementary process to do what I want.