Answer Posted / pooja ahmed

1. When we want to get single return value
2. also we can call this anywhere in the mapping
3. when no.of recs are less go for unconn lkp, which improv
t\da performacesa

Explain about cumulative Sum or moving sum?

1048

---

Describe expression transformation?

1137

---

How can you validate all mappings in the repository simultaneously?

1381

---

whats the logic to load the lower level of granularity of data to fact table.

2281

---

What are the differences between source qualifier and joiner transformation?

1072

---

What is meant by a domain?

1136

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2282

---

what is SDLC way of code development?

2048

---

permutations of mapplet

2517

---

What is the benefit of session partitioning?

1122

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1069

---

What is difference between a gateway node and worker node?

1147

---

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

1098

---

Explain the shared cache and re-cache?

1128

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7197

---