Page 1 of 1
table definition
Posted: Fri May 18, 2012 5:43 am
by 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
Posted: Fri May 18, 2012 6:50 am
by 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.
Tabledefinition
Posted: Fri May 18, 2012 7:49 am
by ntr
priyadarshikunal wrote: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
Posted: Fri May 18, 2012 8:16 am
by 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,