-
1. Re: Some newbie questions
shawkins Jun 12, 2014 2:59 PM (in response to davebally)1 of 1 people found this helpful> These are over unreliable and high latency lines, so what is the impact of the virtualized layer if one or other of those sources is unavailable ?
One of several things. You can let the query error out. You can set what's called partial results mode and we'll make a best effort. Or you can use delegating translator or other mechanism to insert customized error handling.
> Also, If both tables are "customers" both with ids starting at 1, how would we go about creating new surrogate keys or would the simplest thing be to create a composite key of <Server>,<CustomerId> ?
If each source represents different entities, then yes a composite key that includes the source/server would work well.
-
2. Re: Some newbie questions
van.halbert Jun 12, 2014 6:49 PM (in response to davebally)1 of 1 people found this helpfulIf the schemas are the same, you could use the multi-source models option. Which, by default, will perform a union across the multiple sources, and will bypass a source if its off-line. And using the composite key would work.
-
3. Re: Some newbie questions
davebally Jun 13, 2014 6:22 AM (in response to van.halbert)Thanks for the Info