It's all about the answers!

Ask a question

Data Warehouse table with null values allowed


Andrea Ianni (1611916) | asked Jul 28 '09, 9:31 a.m.
Hi guys,
I have written a plug-in to extend the data warehouse with a some custom fields.
For my new DW table I have followed the example "Extending the Data Warehouse".

Now I want to allow null values for some of my columns, how can I do? Must I set some value FieldKind or FieldFlags? If yes, which?

Thanks
Andrea

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Jul 30 '09, 3:54 p.m.
JAZZ DEVELOPER
Andrea, in 2.0, we do collect custom work item fields in the data warehouse.

In general, to keep things simple, we did not allow nulls for fields. For string fields we store "Unassigned" instead of null. We also did this to avoid differences on how various DBs behave with respect to null values.

Your answer


Register or to post your answer.