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.

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What is parameter file?

2 Answers  

---

What are the components of the workflow manager?

0 Answers  

---

what is the flow?

1 Answers  

---

Explain the scenario which compels informatica server to reject files?

0 Answers  

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

What is status code in informatica?

0 Answers  

---