Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2013-04-09 07:34 AM

Difference between tMysqlSCDELT and tMysqlSCD components

Hi All,

What is the difference between tMysqlSCDELT and tMysqlSCD components. ? I've read about these two components in the documentation . I've understood that both serve same purpose. But there should be some differences otherwise we do not have two different components. Can anyone help on this.
Labels (2)
Labels
748 Views
0 Likes
12 Replies
Anonymous
Not applicable
‎2013-04-09 11:58 PM
Author

Hi,
The difference is that the operation of tMySQLSDCELT is available inside a MySql database, however, tMySQLSCD can be used in two MySQL DB.
For example, I have two DB. One is "test" and the other is "test2". If I want to use the SCD technology between "test"and "test2". I only use tMySQLSCD as the solution. Hope it will helpful for you.
Best regards
Sabrina
614 Views
0 Likes
Anonymous
Not applicable
‎2013-04-10 02:05 AM
Author

Hi Sabrina,
Thanks for the info. But what will happen if I use tMySQLSDCELT between two DB. Can u plz elaborate with some samle job..
614 Views
0 Likes
Anonymous
Not applicable
‎2013-04-10 03:44 AM
Author

Hi,
In tMySqlSCDELT component, for the Source Table and the Target Table, there is one Connection. So tMySqlSCDELT component cannot be used in between two DB.
See my pic
Best regards
Sabrina
0683p000009MEIP.png
614 Views
0 Likes
Anonymous
Not applicable
‎2013-07-09 05:06 AM
Author

Thanks for the explanation Sabrina. It helps.
614 Views
0 Likes
Anonymous
Not applicable
‎2013-07-09 05:18 AM
Author

Hi,
You are welcome, feel free post your issue on forum.
Best regards
Sabrina
614 Views
0 Likes
Anonymous
Not applicable
‎2013-07-10 01:06 AM
Author

Hi Sabrina,
Just wish to clarify one thing. Does tMySqlSCDELT is some what related to Extract-Load-Transform (ELT) method while tMySqlSCD is related to Extract-Transform-Load method (ETL).
Can you please put some light on this.
Best Regards,
Mayur
614 Views
0 Likes
Anonymous
Not applicable
‎2013-07-10 02:02 AM
Author

Hi Mayur,
I think you are right. Usually, we choose to use them depending on your situation.
Best regards
Sabrina
614 Views
0 Likes
Anonymous
Not applicable
‎2016-08-29 11:11 AM
Author

Hi Sabrina,
Let me know the purpose of tMysqlSCDELT and tMysqlSCD in briefly.
Many Thanks,
Laddu Rasool.
614 Views
0 Likes
Anonymous
Not applicable
‎2016-08-30 05:52 AM
Author

Hi  Laddu Rasool,
Slowly Changing Dimensions (SCDs) are dimensions that have data that slowly changes. The SCD editor offers the simplest method of building the data flow for the SCD outputs. In the SCD editor, you can map columns, select surrogate key columns, and set column change attributes through combining SCD types.
Please take a look at SCD management methodologies in component reference: TalendHelpCenter:tMysqlSCD.
Best regards
Sabrina
614 Views
0 Likes