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

How do you load alternate records into different tables through mapping flow?

1855

---

Can informatica load heterogeneous targets from heterogeneous sources?

1185

---

what is unit testing?tell me proceedure

2221

---

Can we get 1st record through Informatica(without sequence number).

1479

---

Design time, run time. If you don't create parameter what will happen

1836

---

Explain lookup transformation is active in informatica

1103

---

What are the components of the workflow manager?

1133

---

What is difference between a gateway node and worker node?

1136

---

can we override a native sql query within informatica? Where do we do it?

1122

---

What is update strategy transform?

1100

---

can we override a native sql query within informatica? How do we do it?

1126

---

What is an Integration service in Informatica?

1132

---

Mention some types of transformation?

1045

---

While migrating the data from one environment to another environment how would you manage the connections?

1089

---

What are different types of transformations available in informatica?

988

---