What is the difference between a table and the materialized view?

2 Answers  

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

Differentiate between Load Manager and DTM?

0 Answers  

---

How to start a workflow using pmcmd command?

0 Answers  

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

what are objects in data warehouse?

2 Answers   Mind Tree,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

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

0 Answers  

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---