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
explan ur project architecture?
How do you change a non-reusable transformation to reusable transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
If informatica has its scheduler why using third party scheduler?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
design of staging area?
How to load data in informatica ?
What is the different lookup cache(s)?
What is joiner transformation in informatica?
Define sessions in informatica etl?
What is dimensional table? Explain the different dimensions.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is rank index in rank transformation?
Performance tuning in UNIX for informatica mappings?
if we have a delimiters at unwanted places in a flat file how can we over come those.
