tMysqlSCD & Update Type 1 & 2

Six Stars

tMysqlSCD & Update Type 1 & 2

Hi,

 

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

 

Exemple : 

 

Sur KeyBusKeyCity (Type 1)Mail (type 2) Flag
1adamNYadam@telco.com 1

 

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

 

Sur KeyBusKeyCity (Type 1)Mail (type 2)Flag
1adamSAadam@telco.com0
2adamSAadam.sa@telco.com1

 

The result I expected was

 

Sur KeyBusKeyCity (Type 1)Mail (type 2)Flag
1adamNYadam@telco.com0
2adamSAadam.sa@telco.com1

 

 

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

 

Sur KeyBusKeyCity (Type 1)Mail (type 2)Flag
1adamLAadam@telco.com0
2adamLAadam.sa@telco.com0
3adamLAadam.la@telco.com1

 

 

 

 


Accepted Solutions
Six Stars

Re: tMysqlSCD & Update Type 1 & 2

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

 

I develop complementary process to do what I want.

 

 


All Replies
Twelve Stars

Re: tMysqlSCD & Update Type 1 & 2

can you show the tMysqlScd configuration?

Manohar B
Five Stars

Re: tMysqlSCD & Update Type 1 & 2

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.

 

 

 

Job Design.JPGConfiguration.JPGOutput.JPGOutput2.JPG 

Thanks & Regards
Naveen
Six Stars

Re: tMysqlSCD & Update Type 1 & 2

Tks dasari16

 

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

 

To explain more my case

 

Sur KeyBusKeyCity (Type 1)Mail (type 2) Flag
1adamNYadam@telco.com 1

 

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

 

Sur KeyBusKeyCity (Type 1)Mail (type 2)Flag
1adamSAadam@telco.com1

 

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 KeyBusKeyCity (Type 1)Mail (type 2)Flag
1adamNYadam@telco.com0
2adamSAadam.sa@telco.com1

 

Twelve Stars

Re: tMysqlSCD & Update Type 1 & 2

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

Manohar B
Twelve Stars

Re: tMysqlSCD & Update Type 1 & 2

@pierre,did it help you?

Manohar B
Six Stars

Re: tMysqlSCD & Update Type 1 & 2

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

 

I develop complementary process to do what I want.