Answer Posted / j.david sukeerthi kumar

Hi

Informatica repository is a central meta-data storage place,
which contains all the information which is necessary to
build a data warehouse or a data mart.

Meta-data like source def,target def,business
rules,sessions,mappings,workflows,mapplets,worklets,database
connections,user information, shortcuts etc

What are the performance considerations when working with aggregator transformation?

1155

---

Describe data concatenation?

1085

---

Scheduling properties,whats the default (sequential)

1960

---

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

2272

---

Is it possible to use a client with different version than that of its Informatica server?

1149

---

Explain the types of lookup transformation?

1046

---

What is the benefit of session partitioning?

1116

---

How we can create indexes after completing the load process?

1161

---

What is complex mapping?

1125

---

What is a pre-defined event and user-defined event?

1040

---

How might you approve all mappings in the archive all the while?

1019

---

What is informatica powercenter repository?

1205

---

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,

7188

---

tell me 5 session failure in real time how can you solve that in your project?

2305

---

define galaxy repository in informatica

2232

---