what is the definitions for Datawarehose and Datamart?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
how to unlock a locked job in datastage 8.0
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
What are the different type of jobs in datastage?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
What are transforms and what is the differenece between routines and transforms?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
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
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
how to add a new records into source?
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
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
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