topic Re: tTeradataSCD in Talend Studio

tTeradataSCD

sszzxx — Thu, 15 Feb 2018 05:35:10 GMT

Hi All,

I am using tTeradataSCD to do slowly changing dimension on my table.

I have a table in my Teradata and I would like to give in inputs with updated data and do a SCD type 2.

The question is in the SCD_ACTIVE, it is showing "t" or "f" in the table. I want it to be kept as "Y" and "N" as I have an existing table for this. I have tried to change the type from boolean to string, but it is still showing "t" or "f".

Is there anyway I can set my own return values instead of it passing fixed ("t" or "f") values?

Re: tTeradataSCD

manodwhb — Thu, 15 Feb 2018 05:58:00 GMT

as a expersion in tMap you can convert as you required.

ex:- SCD_ACTIVE.equals('t') ? 'Y' : 'N'

but in tTeradataSCD,you can not able to write expersion like above

Re: tTeradataSCD

sszzxx — Tue, 20 Feb 2018 02:46:13 GMT

Hi Manohar,

Thank you for your reply and suggestion.

Just to confirm, so we cannot manually set the values of the scd_active, am I right?

A walkaround is to put a tmap after the tTeradataSCD component and write the expression to convert the scd_active values?

Thanks

Re: tTeradataSCD

manodwhb — Tue, 20 Feb 2018 04:32:49 GMT

You cannot call the manuall value into scd_active.

Re: tTeradataSCD

sszzxx — Tue, 20 Feb 2018 10:16:12 GMT

Thanks.

I have decided to use tTeradataRow instead and gave Case query instead.

Thank you for your inputs!