what is the difference between OLTP database and data
warehousing database?
Answer Posted / jteo
OLTP (Online Transaction Processing) database design is
normalised, which means it is optimized for INSERT, UPDATE.
Data warehouse design is not normalised but follows
dimensional modelling rules. They involve building star
schemas made up of fact tables and dimension tables and are
optimized for querying (SELECT).
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
what make u disappointmnets in u r career
what are the facilities provided by data warehouse to analytical users?
how would u estimate the size of Aggregator transform data and index cache?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what is the difference between cardinality and Nullability?
what is Forward,Reverse and Re_engineering?
Do we need an etl tool?
What is cube grouping?
when will use SQL override in a lookup transformation?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
dimension object created in oracle can be imported in designer?how?
how do u set partition points in the mapping?
What is a mapping?
what is an ETL or ETT? And what are the different types?