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?
Solved! Go to Solution.
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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.