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 convert table data into xml file using xml output stage? please explain step by step;
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
How many nodes supported by a one cpu in parallel jobs?
How many jobs in ur project? Explain any complex job u have done in ur project?
How do you run datastage job from the command line?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
What is the differentiate between data file and descriptor file?