Usage of tMSSqlSCD component

Highlighted
One Star

Usage of tMSSqlSCD component

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
Community Manager

Re: Usage of tMSSqlSCD component

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Usage of tMSSqlSCD component

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?
Community Manager

Re: Usage of tMSSqlSCD component

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Usage of tMSSqlSCD component

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.
Four Stars

Re: Usage of tMSSqlSCD component

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.

Six Stars

Re: Usage of tMSSqlSCD component

do this [column with space]

 

Four Stars

Re: Usage of tMSSqlSCD component

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.

 

Six Stars

Re: Usage of tMSSqlSCD component

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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.