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.

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

Which files are created during the session rums by informatics server?

0 Answers  

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

---