問題文
A wholesaler's order rows are unique only when the branch code and the order number are taken together. Neither column alone is unique. How is that handled when the stream is set up?
選択肢
- The object accepts a list of key fields and evaluates uniqueness across the whole list, so both columns can simply be designated as keys and a later load with the same combination is recognized.
- Split the file into one file per branch, so each load carries a single branch code and the order number alone can serve as the key for the object.
- Load the rows without a key and rely on the identity resolution ruleset to remove the duplicates afterwards, since matching across sources is exactly what rulesets are designed to do.
- Add a formula during ingestion that concatenates the two columns, and designate the resulting field as the key for the object.