what is the definitions for Datawarehose and Datamart?

Answers were Sorted based on User's Feedback



what is the definitions for Datawarehose and Datamart? ..

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

Is This Answer Correct ?    6 Yes 0 No

what is the definitions for Datawarehose and Datamart? ..

Answer / venugopal

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

Is This Answer Correct ?    4 Yes 2 No

what is the definitions for Datawarehose and Datamart? ..

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.

Is This Answer Correct ?    2 Yes 3 No

what is the definitions for Datawarehose and 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.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Data Stage Interview Questions

how to unlock a locked job in datastage 8.0

3 Answers   HCL,


what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,


What are the different type of jobs in datastage?

0 Answers  


How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,


What are transforms and what is the differenece between routines and transforms?

0 Answers  






diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,


Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,


Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  


how to add a new records into source?

0 Answers  


I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,


5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  


Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  


Categories