On source system, I created a view of a table that exists on that instance, just in a different schema. The view was created in schema called dwadmin. If I describe dwadmin.table on source system, looks great.
On the target system, I tried to create a synonym but I obviously did it wrong because my insert is coming up empty. The schema on the target system is also called dwadmin. So how does the FROM statement in my query know to pull from the schema on the source system?
It must be related to how I created the synonym but that is where I am stuck…
