what is the difference between the active datawarehouse
and datawarehouse
- 1 Answers
- 15055 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
What are the some differences between 7.x and 8.x version of datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How to reverse the string using SQL?
how to sort two columns in single job in datastage.
1)How to Duplicate Records Delete in Sequential file?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
How you Implemented SCD Type 1 & Type 2 in your project?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
How can we improve the performance 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?
Teradata 
