Answer Posted / prats

• Standalone Repository : A repository that functions
individually and this is unrelated to any other
repositories.
• Global Repository : This is a centralized
repository in a domain. This repository can contain shared
objects across the repositories in a domain. The objects
are shared through global shortcuts.
• Local Repository : Local repository is within a
domain and it’s not a global repository. Local repository
can connect to a global repository using global shortcuts
and can use objects in it’s shared folders.
• Versioned Repository : This can either be local or
global repository but it allows version control for the
repository. A versioned repository can store multiple
copies, or versions of an object. This features allows to
efficiently develop, test and deploy metadata in the
production environment.

What could be the possible resons of locks by user?

1096

---

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

1085

---

How we can create indexes after completing the loan process?

1215

---

Can you use flat files in Mapplets.

2657

---

How to differentiate between the active and passive transformations?

1171

---

EXL informatica Questions

1396

---

How do we call shell scripts from informatica?

1127

---

Explain sessions?

1073

---

What do you mean by enterprise data warehousing?

1068

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1093

---

How to use procedural logic inside infromatica?

1249

---

What is incremental aggregation?

1091

---

How do you change a non-reusable transformation to reusable transformation?

1002

---

What can we do to improve the performance of informatica aggregator transformation?

1097

---

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

2428

---