tTeradataSCD

[sszzxx]

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?

[manodwhb · Accepted solution]

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

[sszzxx]

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 

[manodwhb]

You cannot call the manuall value into scd_active.

[sszzxx]

Thanks.

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

Thank you for your inputs!