Fixed year SCD End Date (oracle)

One Star

Fixed year SCD End Date (oracle)

When using the end date for an SCD field, you only have the option of putting the year in (e.g. 9999), which defaults to 01/01/9999. Would like the ability to put in mm/dd/yyyy as a number of our existing projects utilize 12/31/9999 for our SCD Type 2 fields.
Highlighted
One Star

Re: Fixed year SCD End Date (oracle)

yeah that's bad..
i can't specify the date i want to put in there.. only null or some year with 1/1 date..

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.