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

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -