what is the definitions for Datawarehose and Datamart?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3756


What is the method of removing duplicates, without the remove duplicate stage?

584


What is the sortmerge collector?

660


State the difference between an operational datastage and a data warehouse?

602


How the ipc stage work?

673






Explain datastage architecture?

815


How do u convert the columns to rows in datastage?

692


What is the roundrobin collector?

635


how to export or import the jobs in .ISX file

714


Differentiate between operational datastage (ods) and data warehouse?

672


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

347


What a datastage macro?

638


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1757


What is a ds designer?

640


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1635