Interested to Buy Any Domain ? << Click Here >> for more details...
What are the hard ware required for a normal sized data warehouse? and
What are the software required for a normal kind of data warehouse?
- 2 Answers
- 5992 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / itsranjan
Software tools for Datawarehouse:
1)Operating system(Unix or windows)
2)Database(Oracle,DB2 etc.)
3)ETL(Informatica/Abinitio/Datastage/MSBI etc.)
4)Reporting(Business Objects/Cognos/MSBI etc.)
5)Datamodelling(Erwin/Visio etc.)
These are some common softwares i have mentioned.But some
other softwares are also present.
| Is This Answer Correct ? | 4 Yes | 0 No |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Explain the difference between a data warehouse and a data mart?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
How do you take back up of repository?
Mention some types of transformation?
Why we use lookup transformations?
What are the different threads in DTM process?
how to improve performence by using sorted input in aggrigator t/r.
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
What is domain and gateway node?
Teradata 
