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 the use of transformation?

994

---

Plz can any one say me how to get the informatica certification materials and dumps

2044

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2319

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1077

---

What is meant by query override?

1055

---

Explain joiner transformation in informatica

1124

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2129

---

What is complex mapping?

1115

---

What is the Process to creating lookup transformation in informatica

1040

---

What is depict expression change?

1114

---

What is olap (on-line analytical processing?

1063

---

How can we remove the duplicates from flat file source?

1031

---

How to join three sources using joiner? Explain though mapping flow.

1142

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

---

What is the use of target designer?

1044

---