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 |
Name at least 5 different types of transformations used in mapping design and state the use of each.?
with out using update strategy transnsformation how to update the data in mapping level
what is mean by throghput? in informatica
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
What is sequence generator transformation in informatica?
How can we get two output ports in un-connect transformation?
What are the static cache and dynamic cache in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is mapplet and a reusable transformation?
What is a configuration management?
What is a predefined event?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain