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;

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

Define repository tables in datastage?

0 Answers  

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

What is the importance of the exception activity in datastage?

0 Answers  

---