What is synonym?
Answers were Sorted based on User's Feedback
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 |
Answer / mike
A synonym is a alternative name for objects such as tables,
views, sequences , stored procedures and other database
objects.
Is This Answer Correct ? | 2 Yes | 1 No |
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the uses of etl tools?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
What are pre and post-session shell commands?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
What is the difference between view and materialised view?
how to calculate the optimum cache size in aggregator transformation?