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/

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2096

---

What is the difference between stop and abort in informatica

1057

---

Different circumstance which drives informatica server to expel records?

935

---

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

1032

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2160

---

How to configure mapping in informatica?

1141

---

Define Pmrep command?

1016

---

What is union transformation?

932

---

What is data transformation manager process?

1109

---

What is the meaning of up gradation of repository?

1923

---

What is the status code in stored procedure transformation?

1140

---

Can you generate sequence numbers without using the sequence generator transformation?

1078

---

Briefly explain the aggregator transformation?

966

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2018

---

Why is sorter an active transformation?

1077

---