Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suraj kedia
A synonym is nothing but a permanent alias name given to an
existing data base table.
The main concept of synonym is as below;
1)To hide the original table name.
2)To hide the owner of the table.
Synonym can be created on following 3 objects:
1)Table
2)View
3)Synonym
Synonym are of basically 2 types:
1)Public synonym: This can only be created by a data base
administrator.
2)Private synonym: This can be created by any valid data
base user.
Syntax for creating a synonym is
create [or replace] synonym synonym_name for object name;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain the aggregator transformation?
What is dynamic cache?
What are the performance considerations when working with aggregator transformation?
Explain sql transformation in script mode examples in informatica
What is meant by a domain?
Enlist the various types of transformations.
What are the new features of Power Center 5.0?
What is the command used to run a batch?
what is diff b/t sorter t/r and agg have the option sorter property...
complex mapping ur project u r invlve can u explain and give real time example give me ?
what are the Methods For Creating Reusable Transformations?
How can we use batches?
What is a node in Informatica?
What are the settings that you use to configure the joiner transformation?
What are active transformations.
