Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7091 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanchari chowdhury
Records in a OLTP database can be updated or modified or
deleted. However,the same is not possible in DW.
OLTP database is used for transactional purposes e.g. day-
to-day sales or finance and DW is used for analytical
decisions.DW is mainly used for business decisions to
ensure stability of the organisation by curbing the
possible failures. This is possible because it contains the
historical or the archived data for analysis.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
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?
what is the difference between cardinality and Nullability?
What are cubes and olap cubes?
When do we go for the tools in the market?
what are the data modeling tools you have used?(polaris)
tell me few points when u become TL
What is lookup table in etl testing?
Explain about hash partitioning?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is staging area referring to?
What do you understand by the term ‘transformation’?
What is grain of fact?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
how would u estimate the size of Aggregator transform data and index cache?
