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
What are active transformations.
How to generate sequence numbers without using the sequence generator transformation?
Explain the difference between mapping parameter and mapping variable?
How might you approve all mappings in the archive all the while?
where to store informatica rejected data? How to extract the informatica rejected data?
What is Index Caches size?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the need for an etl tool?
What are the designer tools for creating transformations?
Explain the different kinds of facts.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How can you increase the performance in joiner transformation?
Explain load alternative records / rows into multiple targets - informatica
what is Active lock explain
What is a router transformation?
