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 meant by query override?
what are 3 tech challenges/ common issues you face?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the function of union transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What's the layout of parameter file (what does a parameter file contain?)?
What do think which one is the better joiner or look up?
How to delete duplicate row using informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the measure objects?
What is rank transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Mention few advantages of router transformation over filter transformation.
How do you load only null records into target?
in reporting we add some new objects,how we get the count of the newly added objects to the report
