why do we need a datawarehouse when we have databases to store
data?
- 1 Answers
- 4860 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sriram
Database contains data called production data mostly and we can do operations but not recommended which is a performance issue and is always busy with application data
where as in DW,the data which we maitain is called historical data, on which we can play around.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Describe routines in datastage? Enlist various types of routines.
Name the third party tools that can be used in datastage?
How the ipc stage work?
How to perform incremental load in datastage?
Define Data Stage?
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
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between orabulk and bcp stages?
Differentiate between datastage and informatica?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the difference between validated and compiled in the datastage?
What is apt_config in datastage?
