what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

How to enter same record twice in the target table,explain?

7 Answers  

---

Can we create two repositories on same database instance in oracle?

0 Answers  

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

What is incremental aggregation?

0 Answers  

---

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

---

what is incremental data aggregation?

3 Answers   IBM,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

COM components can be used in Informatica

0 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---