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

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7454

---

Briefly describe lookup transformation?

1046

---

Define sessions in informatica etl?

1035

---

What is a sequence generator transformation?

1021

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

---

What are the types of schemas we have in data warehouse and what are the difference between them?

942

---

can you please explain me pre session and post session options?

7570

---

What is data transformation manager process?

1158

---

Please let me know how to make encryption and decryption with example?

1902

---

What is the difference between a repository server and a powerhouse?

1513

---

What is primary and backup node?

1128

---

Can we create multiple integration service on single repository?

1188

---

How to open an older version of an object in the workspace?

1207

---

What is resilience time?

1143

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---