Interested to Buy Any Domain ? << Click Here >> for more details...
What is the need of building a data warehouse?
- 2 Answers
- 4947 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashish goel
Data warehouse is generally designed for analyzing the
business operations but not to run the business operations.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vas.chiky
Having separate OLAP DWH database for analysis, increases
the performance of reports.
even during backup or crash period of oltp, OLAP database
will not get affected.
| Is This Answer Correct ? | 1 Yes | 0 No |
how can u load the data in time dimension?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
Parameter and variable differences
Why touse stored procedure in ETL Application?
what is the significance of newlookup port in dynamic look up
What are limitations of joiner transformation?
What are the components of workflow manager?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How do you load alternate records into different tables through mapping flow?
Can we make worklet inside worklet?
How we can create indexes after completing the loan process?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
Teradata 
