Answer Posted / dhanakkodi

I have two tables emp and dept

i want some employees those who are in the some department
for this situation i have to join two tables.
In this situation both table foreign keys are in the Fact
table means we can easily get the information and also
factless fact table is used for get the count from the
table.

-- Dhanakkodi

Explain in detail scd type 2 through mapping.

1050

---

How we can create indexes after completing the loan process?

1215

---

Does an informatica transformation support only aggregate expressions?

1049

---

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

1171

---

waht type of interface is used for testing the data in informatica

2259

---

Differentiate between a database and data warehouse?

1148

---

how many types of dimensions are available in informatica?

1105

---

Write the unconnected lookup syntax?

1087

---

On which transformations you created partitions in your project?

1350

---

Mention few power centre client applications with their basic purpose?

956

---

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

2135

---

Explain the mapping variable usage example in informatica

1167

---

What are the different options available for update strategy?

1005

---

Why do you use Mapping Parameter and mapping variable?

1773

---

Tell me about MD5 functions in informatica

930

---