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 do you mean by filter transformation?

953

---

how to load rows into fact table in data warehouse

1190

---

Difference between Data and Index Caches?

1141

---

What is olap (on-line analytical processing?

1071

---

Performance tuning in UNIX for informatica mappings?

2570

---

what are the Methods For Creating Reusable Transformations?

1177

---

What are the data movement modes in informatica?

1163

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008

---

Mention a few design and development best practices for informatica?

999

---

Briefly describe lookup transformation?

1046

---

What are the static cache and dynamic cache in informatica?

1194

---

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

943

---

How can we use mapping variables in informatica?

1063

---

Is there any target staging area in informatica not staging area

2580

---

Write the program through which the records can be updated?

1007

---