History_Preserving Error with Data Types

[former_member202087]

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.   

[Former Member · Accepted solution]

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

[former_member202087 · Accepted solution]

Thanks.  I think that got it.  I mapped bith the start and end dates with system date, rebuilt my template table, and my HANA table, and then it seemed to work. 

[Former Member · Accepted solution]

Glad to know.

Arun

[former_member27665 · Accepted solution]

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.