what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5904 Views
- I also Faced
- E-Mail Answers
Answer Posted / parvar
The main difference between oltp and dw are,
Oltp dw
1 current data historical data
2 normalized data de-normalized data
3 small database large database
4 application-oriented subject-oriented
5 row by row loading bulk loading the data
The data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is different between sequential batch and concurrent batch and which is recommended and why?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
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.
Which transformation we use to convert 'NA' to 'Not Available'
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
list and discuss two approaches for updation of target table in Informatica and how they are different.
Explain what is etl process? How many steps etl contains explain with example?
how would u estimate the size of Lookup transform data and index cache?
how do use session mapping parameters ?(in which transformation)
What are cubes and olap cubes?
What is etl tool in hadoop?
tell me few points when u become TL
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What is tracing level?
