tTeradataSCD

Highlighted
Six 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?


Accepted Solutions
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Six 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 

Forteen Stars

Re: tTeradataSCD

You cannot call the manuall value into scd_active.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: tTeradataSCD

Thanks.

 

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

Thank you for your inputs!

 

 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch