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
sed,awk,head
What can we do with datastage director?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What all the types of jobs you developed?
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?
How do y read Sequential file from job control?
how can we create rank using datastage?what is the meaning of rank?
Distinguish between informatica & datastage. Which one would you choose and why?
What is job control?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the functionalities of link partitioner and link collector?
Describe the architecture of datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this