what is the difference between the active datawarehouse
and datawarehouse
Answer / ram
An active data warehouse (ADW) is a data warehouse
implementation that supports near-time or near-real-time
decision making. It is featured by event-driven actions
triggered by a continuous stream of queries (generated by
people or applications) against a broad, deep granular set
of enterprise data.
Diff:
Active Data Warehousing Allowing access by customers,
partners and suppliers at the same time;
Integrating multi-subject, cross-channel information to
optimize business opportunities;
Allowing fully detailed ad hoc reporting and machine
modeling, such as data mining, to discover new hypotheses;
| Is This Answer Correct ? | 3 Yes | 0 No |
how to sort two columns in single job in datastage.
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
How to delete the data in dataset?types of deleting the data in dataset?
how to delete one row in target dataset
What is the difference between an operational datastage and a data warehouse?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is data partitioning?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the types of hashed files in data stage
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
which r the connectors used in san?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this