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
What is mapping debugger?
What are the databases that informatica can connect to windows?
What are the advantages of informatica?
What do you mean by blocking transformation?
How to load last n records of file into target table - informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
list out all the transformations which use cache?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to differentiate between the active and passive transformations?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the types of lookup transformation?
What is fact table? Explain the different kinds of facts.
