I am retrieving a set of columns from a table, one of the column is timestamp (Create_Ts) and directly writing into a file. I gave timestamp in datastage stages (Both OCI and File). But it is coming blank in file. Size of the timestamp columns in both the stages are 19. Even if i increase the column size the field is blank in the file.
I can make it varchar in both the ends, incase if at all want to do some transaction at trasnformer, what should i do?
I think varchar on both ends works great. It stores it internally as varchar anyway. DataStage itself is faster in a server job to use varchar on most everything. You only need the real type on a plugin like a bulk load. DataStage will handle the conversion at that point.
PX jobs are very different in regards to metadata like this.
Craig is correct. The newer date types added milliseconds and some of the routines break. DataStage itself may not handle a new data type on a new release of a database. You may have to use varchar in that case.