table definition

[ntr]

Hi,

I had created a table in the oracle database one of the field in that table

is valdate datatype of that field i had given date

but when iam importing that table definition into datastage it automatically

coming as timestamp can please help me how to import that table

definition as date datatype

Thanks

[priyadarshikunal]

what the import wizard is doing is correct as thats how it is interpreted in it.
Oracle database's date can store date as well as time component hence the equivalent of it will be timestamp. A timestamp in oracle can store fractional seconds for which you need to use the extended property of timestamp datatype in datastage i.e. microseconds.

[ntr]

what the import wizard is doing is correct as thats how it is interpreted in it.
Oracle database's date can store date as well as time component hence the equivalent of it will be timestamp. A timestamp in oracle can store fractional seconds for which you need to use the extended property of timestamp datatype in datastage i.e. microseconds.

Thanks priyadarshikunal

but when iam preparing a dataset for that table with generic job the

datatype loading into dataset as timestamp

but i want to prepare a dataset with date datatype

why because iam comparing that dataset to another dataset .that datasets

datatype is date

please tell me how to achieve this




Thanks

[jwiles]

You can use TimestampToDate() in a transformer to extract the date portion of a timestamp. Read more about it in the Parallel Job Developer's Guide.

Regards,