What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

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  

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

When the informatica server marks that a batch is failed?

1 Answers  

---

What are the scheduling options to run a sesion?

2 Answers  

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

---

what is the process of target load planing?

2 Answers   IBM,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---