topic Re: Usage of tMSSqlSCD component in Talend Studio

Usage of tMSSqlSCD component

Anonymous — Sat, 16 Nov 2024 13:38:37 GMT

Hi everyone,
I need to read from a SQL Server only changed rows. I red that tMsSqlSCD is the right component but I don't know how configure it.
Could you help me please?
Thks
Gisella

Re: Usage of tMSSqlSCD component

Anonymous — Fri, 18 Dec 2009 03:25:55 GMT

Hello
About SCD(Slowly changing dimension), you could read an introduction. About tMsSqlSCD, please read the user documentation, there is a demo on tMySQLSCD part.
Best regards
shong

Re: Usage of tMSSqlSCD component

Anonymous — Fri, 18 Dec 2009 14:59:10 GMT

Thanks shong!
But now I have one other problem.
I have some fields that contains spaces or number in the field name: for example "Search Description" is a field name or "Vendor Item No_" or "4x4".
This kind of names causes compliation problems in talend. But if I try to change it I have SQLException in insert/update phase.
How can I resolve that?

Re: Usage of tMSSqlSCD component

Anonymous — Mon, 21 Dec 2009 06:24:12 GMT

Hello

for example "Search Description" is a field name or "Vendor Item No_" or "4x4".

When i look into the generated code, i see some code like:

    class SCDStruct_tMysqlSCD_1 {
private Integer 4x4;
private String f f;
}

The string is invalid in Java if the column name contains some space or starts with digit. So, please report a bug on our bugtrack, we need handle the special characters first.
Best regards

shong

Re: Usage of tMSSqlSCD component

Anonymous — Thu, 01 Mar 2012 11:46:02 GMT

I am having problems with SCD components. Please explain me in detail what is this components all about and how to incorporate this 'tmssqLSCD' or SCD in job design.

Re: Usage of tMSSqlSCD component

Anonymous — Mon, 02 Jul 2018 10:55:24 GMT

I have the same issue - SCD component does not work for tables which have spaces in column names. I use version 6.4.1. I see that the first post is from year 2009 and now it is year 2018, so I do not know if it appropriate to ask for help of a fix. I will come back to celebrate 10 year anniversary of this issue.

Re: Usage of tMSSqlSCD component

Anonymous — Tue, 03 Jul 2018 10:35:24 GMT

do this [column with space]

Re: Usage of tMSSqlSCD component

Anonymous — Tue, 03 Jul 2018 12:39:53 GMT

This is a topic about tMSSqlSCD in Talend Open Studio, so DO THIS: please reply about the issue in question and not some unrelated matter.

Re: Usage of tMSSqlSCD component

Anonymous — Tue, 03 Jul 2018 13:13:39 GMT

I will do this [IGNORE] you're probably using type 4