Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7427 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 data modeling and data mining?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What are your responsibilities as an etl tester?
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?
Explain different types of partitioning?
What are the key benefits of ETL Testing?
can cubes contain measures ?
State the differences between shortcut and reusable transformation
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
where are the log files generally stored.Can you change the path of the file.what can the path be?
what is the main role of FI on business
In Which Transformation We Can Use Having Clause In Informatica?
how do u implement configuration management in Informatica?
What are materialized views & where do we use them?
flat filevalidation in informatica
