Answer / 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;

Answer / mike

A synonym is a alternative name for objects such as tables,
views, sequences , stored procedures and other database
objects.

What are the new features of informatica 9.x at the developer level?

0 Answers  

---

What is polling in informatica ?

1 Answers   TCS,

---

What is joiner transformation?

0 Answers  

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  

---

What are the different caches used in informatica?

3 Answers   UST,

---

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

Write the unconnected lookup syntax?

0 Answers  

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---