1 of 1 people found this helpful
Hi Ricardo -
You're looking for the equivalent of a RIGHT JOIN (Primary = Left, Secondary = Right), and unfortunately Blending doesn't support this.
If you make your Secondary DB your Primary, you'll be able to see all customers, at the cost of losing the use of your dimensions from the database that is now Secondary -- this won't work either.
Is there any chance you can actually do the join at the level of the data itself? For example, if this was SQL Server and two databases live on the same (or different) servers, you could do something like this:
Select PrimaryTable.*, SecondaryTable.*
PrimaryTable RIGHT JOIN SQLServerName.SecondaryDatabaseName.dbo.SecondaryTable SecondaryTable
ON PrimaryTable.Customer = SecondaryTable.Customer
Sorry for this late thanks, but I didn´t see your post.
I will try with the help of some friends and let you know something.
Thank you once again