Answer Posted / ratalarayudu

hi,

The main purpose of unconnected lookup t/r is

1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.

regards,
rayudu.

Partition, what happens if the specified key range is shorter and longer

2557

---

How identifying bottlenecks in various components of informatica and resolving them?

1181

---

What are the differences between source qualifier and joiner transformation?

1137

---

How can we use mapping variables in informatica? Where do we use them?

1291

---

In development project what is the process to follow for an etl developer from day1

1760

---

What is option by which we can run all the sessions in a batch simultaneously?

1194

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1139

---

What are ETL Tools?

1175

---

What do you understand by term role-playing dimension?

1119

---

What is meant by query override?

1118

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481

---

What are the types of data warehouses?

1577

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2259

---

Explain what is informatica metadata and where is it stored?

1109

---