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
- 6081 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 |
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
What is the Rankindex in Ranktransformation?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
Which is the best place to learn Informatica Powercenter Online Training?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
what is the use of Java Transformation in Informatica 8.x?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
What is a grid in Informatica?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
daily how much amount of data send to production?
Teradata 
