Answer / swetha

The PowerCenter repository allows you to share metadata
across repositories to create a data mart domain. In a data
mart domain, you can create a single global repository to
store metadata used across an enterprise, and a number of
local repositories to share the global metadata as needed.

What is the sequence generator transformation in informatica?

0 Answers  

---

Why we use partitioning the session in informatica?

2 Answers  

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

What is DTM process?

4 Answers  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

what is mapping performence?

2 Answers   Cap Gemini,

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---