What is the need of building a data warehouse?
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 |
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
How are the sources and targets definitions imported in informatica designer?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
what is the difference between static and dynamic
How can you access the remote source into your session?
can anyone explain me about retail domain project in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
In which scenario did you used pushdown optimization?
what is the process we used in joiner transformation,there is no matching column in sources?
Why we require dwh in particular projects?