Answer Posted / arun

Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.

Space consumed is more than snow-flake

What is mapplet in informatica?

1041

---

What is native users?

1139

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2149

---

Explain about cumulative Sum or moving sum?

1021

---

update strategy transformation in informatica

1051

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5643

---

What is a dimensional model?

963

---

Explain the different lookup methods used in informatica?

1023

---

Briefly explain the aggregator transformation?

985

---

Explain the scenario which compels informatica server to reject files?

1146

---

What is substr in informatica?

1180

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1492

---

What could be the possible resons of locks by user?

1078

---

Enlist few areas or real-time situations where informatica is required.

1060

---

What are the types of schemas we have in data warehouse and what are the difference between them?

923

---