Answer Posted / rahul patil

All the above approaches are not correct because question was to join two flat files... if we use indirect file or unix command or joiner trns, we could only union two files but not join.

If we have file1 --- 100 records and
file2 --- 100 records then through above approaches we would have only 200 records.

But a join without join condition would return cartesian product and in our case count should be 10000.


Rahul Patil
DWHKID

What is olap (on-line analytical processing?

1069

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1856

---

Explain incremental aggregation in informatica

1131

---

What are different types of transformations available in informatica?

993

---

What is a repository? And how to add it in an informatica client?

1149

---

Difference between Data and Index Caches?

1138

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1076

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

---

What is informatica? Why do we need it?

1101

---

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.

2201

---

How can a transformation be made reusable?

1171

---

According to his methodology what all you need before you build a datawarehouse

1759

---

What are data-driven sessions?

1213

---

Explain what are the different versions of informatica?

1099

---

How to configure mapping in informatica?

1173

---