Skip to Content

History_Preserving Error with Data Types

I am creating a History_Preserving transformation. When I try to run my job I am getting an error messge that states "Data Type of column <START_DATE> specified in option <valid_from_column> for the History_Preserving transform must exactly match the data type of column <END_DATE> specified in option <valid_to_column>."

Both my START_DATE and END_DATE are defined with date type DATE. My start date is populated with sysdate and my end date is populated with null. Within the History_Preserving transform I am setting the new record to a valid To date of 9999.12.31 and the old record to "one day before valid from_date of new record".

My dataflow is Source --> QUERY TRANSFORM --> TABLE COMPARISON --> HISTORY PRESERVING --> KEY GENERATION --> TARGET.

I have a feeling I am missing something simple but have not had luck finding much reference to this issue online. Any help would be appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2013 at 02:36 PM

    I dont think so that end date be a NULL value. You have to insert a value, if not date may be a numeric value. Later in the database you can change the numeric value to NULL using a DS script or something.

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

    • I encounter the same error “ Data Type of column <START_DATE> specified in option <valid_from_column> for the History_Preserving transform must exactly match the data type of column <END_DATE> specified”. Eventhough the START_DATE and END_DATE were defined with date type DATE.

      I re-imported the target table (Oracle) and this fixed the issue.😊

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.