Split data by Date

Question

I am importing a .CSV file for an HRIS project that will report New Hires and Terminations. I have one report that shows the following date.

|PersNo|Name|EntryDate|TermDate|

I want to split the date so that the people with the Term dates go into one DB and the people with NewHire dates go into another DB.

I think a Conditional Split is the answer but it doesn't seem to want to work. I had the conditions set as such:

|1|EntryDate == EntryDate|
|2|TermDate == TermDate|

I have also thought about a slowly changing dimension. Creating an employee table with all employee information that will reference the information from the Hire/Fire Report and add the Term Date to any employee (using employee number as the relation) that has a term date appear.

Any thoughts on how I should develop are welcome.

Answer 1

You might check for nulls in your condition. For example, ISNULL([TermDate]) == FALSE might indicate a row to be sent to the termination destination.