does DS support private synonyms from different schemas

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pavanns
Participant
Posts: 27
Joined: Wed Sep 28, 2005 8:00 pm
Location: ca

does DS support private synonyms from different schemas

Post by pavanns »

Hi,
I am trying to import metadata frm schema but am not able to see the synonyms created in the schema from the other schema..

say for example i have 2 schemas a,b
i have created a public synonym in 'a' for a table of 'b'..tried to import the same table def from 'a'(which i have access to in DS)...how ever i donot find the table or synonym created in the schema 'a'.how should i import the metadata frm a public or private synonym created..does DS support importing tables(synonyms created on diffetrent schemas)...

i am able to see views but that does not help me in dynamic environment as i donot have access to schema 'b' which is wholly used for a secured functionality that cannot be discussed across teh business...
pavan
pavanns
Participant
Posts: 27
Joined: Wed Sep 28, 2005 8:00 pm
Location: ca

i apologise...

Post by pavanns »

i apologise for posting in enterprise edition but any views on this issue would be appreciated
pavan
Post Reply