I have a simple job that reads from my date dimension and writes into a hash file. One of the fields of Date datatype is read as a timestamp in my oracle connector using the mask YYYY-MM-DD HH24:MI:SS. I'd expect the timestamp to read something like
Code: Select all
2014-06-11 00:00:00
Code: Select all
2014-06-11 12:00:00