Answer Posted / ankit kansal

Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.

http://deepinopensource.blogspot.in/

Explain how to import oracle sequence into informatica?

953

---

What is the need of an ETL tool?

1029

---

What is informatica? Why do we need it?

1041

---

What is the benefit of partitioning a session?

1105

---

How to load data in informatica ?

956

---

What is the command used to run a batch?

997

---

Is it possible to revert a global repository to local one and why?

1026

---

Explain lookup transformation source types in informatica

1043

---

Enlist the advantages of informatica.

1007

---

How to load the data from people soft hrm to people soft erm using informatica?

953

---

have u done any performance tuning? how u ll do?

2249

---

What are active and passive transformations?

1023

---

How do you take back up of repository?

1095

---

What is confirmed fact in dataware housing?

6805

---

What is the advantage of informatica?

1016

---