Answer / yarramasu

Datawarehouse is nothing but collection of logical data its
maintain historical data. Datamart is subset of
datawarehouse and its maintained dependent and independent

Answer / venugopal

DataWareHouse is a huge database to maintain the historical
data. where as Datamart is a subset of DWH.

Answer / sagar

Datamart is subset of Datawarehouse we can say ....a
datamart is collection of individual departmental
information...
Where as datawarehouse in collection of datamart.

Answer / maruthi

BASICALLY DWH ARE DOMAIN ORIENTED IN THE SENSE DWH STORES
DATA ACCORDING TO DOMAINS,SO DATA MART IS DWH OF PARTICULAR
DOMAIN(SALES,PRODUCTION,ETC)
WHEN WE GET TOGETHER ALL THIS DOAMINS OF A SINGLE COMPANY
THEN IT IS CALLED AS DWH.

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

What is the use of Row generator stage?

2 Answers  

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

Define meta stage?

0 Answers  

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,

---

What are orabulk and bcp stages?

0 Answers  

---