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
How to do unit testing in informatica?
Why update strategy and union transformations are active? Explain with examples.
Explain about cumulative Sum or moving sum?
What is substr in informatica?
What is source qualifier transformation in informatica?
What is sequence generator transformation in informatica?
How to use pmcmd utility command?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What can we do to improve the performance of informatica aggregator transformation?
differences between service based and product based?
can we override a native sql query within informatica? How do we do it?
What are different types of transformations available in informatica?
Why filter transformation is an active one?
What is the difference between a repository server and a powerhouse?
What do you mean by enterprise data warehousing?
