Answer Posted / bidhar

If the structure of 100 tables and the target table are
same then what is the use of joiner??

Here you need to do a Union.


If the structure of 100 tables and the target table are not
same then joiner should be used.
That means you will be picking up the desired Attributes
(columns) from these 100 tables and populating into the
target.

Please let me know your question clearly.

How many number of sessions can one group in batches?

1140

---

What is meant by lookup transformation?

1084

---

Enlist some properties of sessions.

1053

---

How can informatica be used for an organization?

1193

---

How we can create indexes after completing the load process?

1145

---

In informatics server which files are created during the session rums?

1104

---

Differentiate between a repository server and a powerhouse?

1099

---

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

2119

---

differences between service based and product based?

1996

---

Clarify the aggregator change?

1012

---

Define the various join types of joiner transformation?

979

---

Which transformation should we use to normalise the COBOL and relational sources?

1181

---

Briefly explain the aggregator transformation?

983

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1897

---

What are ETL Tools?

1096

---