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 is incremental aggregation?

0 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

How to use Normalizer transformation?

2 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

---

What is the session task and command task?

0 Answers  

---