DT_1,FACT_SEQ,INT_DT_DIM_SEQ,INT_TIME_DIM_SEQ,SMPL_TIME_DT_DIM_SEQ,SMPL_TIME_TIME_DIM_SEQ,MACHINE,DELTA_TIME
7-Jun-12,1188999,20120607,111500,20120607,41500,5724,189
7-Jun-12,1188485,20120607,3000,20120607,41500,1234,189
I need to get the timestamps created based on INT_DT_DIM_SEQ, INT_TIME_DIM_SEQ fields. The problem is INT_TIME_DIM_SEQ has values like 221500 which is 22:15:00 and sometime 3000 which is 00:30:00 and 15000 which is 01:50:00. I tried TimeFormat %Y%m%d%H%M%S and time fields as INT_DT_DIM_SEQ,INT_TIME_DIM_SEQ but it is taking incorrect times in cases where there are no leading zeroes in the data feed.
... View more