what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 6055 Views
- I also Faced
- E-Mail Answers
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
Explain the key challenges that you face while performing etl testing.
how many maximum session supports to multiload in teradata ??
Identifying the bottlenecks in various components of Informatica and resolving them.
How many types of transformations supported by sorted input?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
tell me few points when u become TL
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is data cleaning?
What is lookup table in etl testing?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What do you understand by the term ‘transformation’?
Two default user groups created in the repository are____and_____.
Can anyone explain me a scenario from banking and finance...more precisely a mapping
