Hi
Due to the source data structure, I need to concatenate the values of 2
fields ('supplier_id' and 'product_id') to form the unique 'id' of each
document.
However there are cases where some documents only have 'supplier_id' field.
This will result in some documents with a longer/larger 'id' field (have
both 'supplier_id' and 'product_id') and some with a shorter/smaller
'id' field value (has only 'supplier_id').
Please refer to simplified representation of the records below.
3rd record only has supplier id .
ts1 sup1 pdt1
ts1 sup1 pdt2
ts1 sup2
ts1 sup3 pdt3
ts1 sup4 pdt5
ts1 sup4 pdt6
I understand the unique 'id' is use during indexing to check whether a
document already exists. Create if it does not exists else update if it
exists.
Are there any implications if the unique 'id' field value is of
different size/length among documents of a collection?
Is it advisable to have such design?
Derek
----------------------
CONFIDENTIALITY NOTICE
This e-mail (including any attachments) may contain confidential and/or privileged information. If you are not the intended recipient or have received this e-mail in error, please inform the sender immediately and delete this e-mail (including any attachments) from your computer, and you must not use, disclose to anyone else or copy this e-mail (including any attachments), whether in whole or in part.
This e-mail and any reply to it may be monitored for security, legal,
regulatory compliance and/or other appropriate reasons.
