Five Stars

tTeradataSCD

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: tTeradataSCD

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

Manohar B
4 REPLIES
Ten Stars

Re: tTeradataSCD

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

Manohar B
Five Stars

Re: tTeradataSCD

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 

Ten Stars

Re: tTeradataSCD

You cannot call the manuall value into scd_active.

Manohar B
Five Stars

Re: tTeradataSCD

Thanks.

 

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

Thank you for your inputs!