Other: LDP - Split pool/cluster tables to different targets with the same source
Hello,
This is related to support ticket 179774.
Our current setup has multiple channels and sources with only one source but 4 targets.
Most of these channels have clustered and pooled tables but the problem is we cannot pick and choose which clustered or pooled tables we want for specific targets. The problem is with how LDP works now, if a pooled table is replicated in one target, it should be replicated in all targets. This is not how we want this to work.
For example in a channel, we have SQL Targets Target1 and Target2.
On Target1 we only want Pool1 to be replicated.
On the other Target we want Pool1 through Pool9.
So on Target1 we only create the structure of Pool1 because this is the only table we want replicated there.
We are going to get an error here where it says 'F_JD21B4: DBMS error [[ODBC Driver 17 for SQL Server][SQL Server]Invalid object name' because Pool2 through Pool9 doesn't exist in Target1.
Target2 is going to work just fine.
Even if we add Absent Properties it still wouldn't work. Even if we only add the PackedInside action for Pool1 on Target1, it still tries to send the other Pooled tables to Target1.
Which isn't ideal and not what we want for the users as they will be forced to have useless tables in their Database Targets so we need help here.
Please sign in to leave a comment.
Comments
0 comments