why do we need a datawarehouse when we have databases to store
data?
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
What are system variables and sequencers in datastage
What is oci?
What all the types of jobs you developed?
How to reverse the string using unix?
What is a datastage job?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the use of hoursfromtime() function in transformer stage in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define meta stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
what is the use of surogate key in datastage
Highlight the main features of datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
To see hidden files in LINIX?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.