Answer Posted / 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;

Differentiate between Join, Merge and Lookup stage?

656

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1057

---

How a source file is populated?

626

---

Differentiate between datastage and datastage tx?

609

---

Can you explain engine tier in information server?

661

---

---

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

558

---

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?

1770

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

636

---

What are the some differences between 7.x and 8.x version of datastage?

751

---

What are the different types of lookups in datastage?

638

---

How the ipc stage work?

682

---

What are data elements?

667

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

909

---

What a datastage macro?

647

---

How do you generate sequence number in datastage?

633

---