What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

what is constraint based loading

2 Answers   IBM,

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

What is powercenter on grid?

0 Answers  

---

Define pmcmd command?

0 Answers  

---

What is hash partition?

2 Answers  

---

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

How can a transformation be made reusable?

0 Answers   Informatica,

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---