What is the need of building a data warehouse?
- 2 Answers
- 4247 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 FACT TABLES?
In a concurrent batch if a session fails, can you start again from that session
Explain Dataware house architecture .how data flow from intial to end?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
what is diff between IN and EXIT commands
lookup transformation with screenshots
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
How we will implement Pushdown Optimization and Types in Informatica with better examples
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
how to join the 2 different table with different columns in informatica?
Differentiate between joiner and lookup transformation?
Teradata 
