M
Minollo
Guest
Tough to tell; are you modeling a single object in the template, mapped to a single Salesforce object, and then "enriching" that single object with fields from other Salesforce objects - relying on data source relationships you have defined? Or are you creating multiple objects in the template, each of them mapped to a Salesforce object, and then defining data set relationships? A few things to remember: - data source relationship are used by Easyl during "data load", to do enrichment when fields in a single object are contributed by multiple physical tables - data set relationship are used only when creating reports, and not during data load - if you are connecting to a single data source, and doing "Add Mapping" multiple times for the same data set object, you may be misunderstanding "enrichment" with "merging": multiple mappings for the same object implies that you are merging records from multiple tables - but each record is defined independently (think about SQL UNION); if what you are trying to do is enrichment, you are actually adding a field to an object, clicking on the right column and then navigate data source relationships there to reach the field you want to use for enriching (think about SQL JOIN).
Continue reading...
Continue reading...