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.

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

---

waht is dataware house

2 Answers  

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

What are different types of transformations available in informatica?

0 Answers  

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

What are the tasks that source qualifier perform?

0 Answers   Informatica,

---

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

---

what is constraint based load order

2 Answers   Cap Gemini,

---