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 |
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do you get log info into a file?
why we use parameters instead of hard code in datastage
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
What are orabulk and bcp stages?
whom do you report?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
Define Job control?
How and where you used hash file?
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is factless fact table?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.