DSXchange

i have a timestamp column in a sequencial file with a sample value as "2006-02-25 12:10:22.324555", but i am not getting the 6 decimal in output

Are you going into database? Sequential File? What's the data type you are using to read the timestamp (leangth as well)?

I have you tried putting a peek right after the file stage to see if the data is being read by data stage correctly?

i am using to read from a seuential file, and after transform insert into teradata table

Keshav,

While reading from the sequential file stage, define the particular time stamp column as, SQL Type: "Timestamp" and Extended: "Microseconds" in the output -> columns tab. Give values for length as 26 and scale as 6.
Hope this will solve your problem .

Best Regards,
Sajarman.

Also check the teradata default timestamp settings.

i do not find the "Extended" column property

keshav0307 wrote:i do not find the "Extended" column property

Right click on the Field properties grid. You can find the list of check option. Extended option might be unchecked.

You should go by the book. :D

Hi Double click you sequential file stage and click the output button and then Columns tab. Inside that right click and select properties inside that you will find Extended column in Position 4