left join - Oracle Endeca Commerce:- Duplicate properties after joining -
i have 2 data sources 1) atg_data (data source 1) , 2) text record. after joining both sources output not coming desired.
for example,
there 2 records (present in both sources). both records have these 3 properties definalty have other properties well.
item id vendor id ranking(p_commptp)
record 1 703595 2560 10 record 2 703595 5638 11
but final record after joining (left join)
item id vendor id ranking(p_commptp)
record 1 703595 2560 10
record 2 703595 5638 11
record 3 703595 2560 10 11 record 4 703595 5638 10 11
two more records getting created, ranking merged.
in pipeline, caching data based on following index.
atg data - 1) item number
2) vendor id
text file - 1) item number
we using left join.
i not able understand why 2 more records getting created. doing indexing @ sku level. , these 3 properties doesn't signify uniqueness of records. can u please me in this?
in record assembler screen in pipeline diagram (where configure join type, etc), experiment 2 check boxes "multi-sub records" , "remove duplicate property values". think first 1 might this.
Comments
Post a Comment