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?


One answer

permanent link
Rafik Jaouani (5.0k16) | answered Jul 30 '09, 3:54 p.m.
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.