Interested to Buy Any Domain ? << Click Here >> for more details...
What is the need of building a data warehouse?
- 2 Answers
- 4731 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 |
What is the functionality of update strategy?
What are the challenges you have faced in your project?
how many ways can we implement SCD2?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
What is decode in static cache?
What is meant by lookup transformation?
What are the uses of a Parameter file?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
How to update or delete the rows in a target, which do not have key fields?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
What is the function of look up transformation?
Can a joiner be used in a mapplet.
Teradata 
