DataManager: Modify data types in fact build?

[goodknight]

Stupid question, but is there a way to modify the data types that DataManager uses when doing a fact build?

It's using a TIMESTAMP data type, but I need it to be DATE.

Thanks!

[MFGF]

Hi,

Do you mean the datatypes used when Data Manager creates a table for you?  You could try:

a) Editing the properties of your datastream items to define a datatype for each.
b) Having a SQL node (from a jobstream) create the table for you using datatypes and sizes you specify.

Regards,

MF.

[goodknight]

Good catch!  Thanks again!