DSXchange

The Three timestamp columns are CTCSTRGMTS, BUSINESSPROCESSGMTS, BUSINESSPROCESSENDGMTS. length is 26 and scale is 6 in source. Later the lenght and scale are taken blank in transformer and the extended properties are unchecked. Only BUSINESSPROCESSGMTS column is being populated with microseconds in...

@SURA: I have already tried writing the data into sequential file. There i could see timestamp columns without microseconds, but the problem is when we write it into a dataset. One important thing is that after transformer stage we have used many lookups where this timestamp column is a direct mappi...

Hi, I have developed a parallel job in which the source dataset has three timestamp columns. The extended property for these columns are disabled in transformer stage to truncate microseconds into the target. The vierd thing is that one of the timestamp column is populating data with microseconds in...