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
- 5982 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 |
What are the different types of transformation available in informatica.
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
How to delete the data in the target table after loaded.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to recover the standalone session?
How to Join Tables my Source is having 15 table target is one?
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
In joiner, how to load Master table in Target?
What is enterprise data warehousing?
what is the necessity to use update strategy?(except for updates)
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Which files are created during the session rums by informatics server?
Teradata 
