What is the difference between a W/H and an OLTP application?
Answer Posted / bindu
W/H maintains subjectoriented,timevariant,histrorical data.
where as OLTP apllications maintains current data, and it
gets updates regularly. ex:ATM machine,Railway reservations
etc.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What is mean by aggregate aware?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Difference between cold fusion mx 6 and cold fusion mx 7?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is the difference between star and snowflake schemas?
Explain what is ods (operation data source)?
How can you implement many relations in star schema model?
What are the advantages of raid 1, 1/0, and
Explain difference between data ware house & data mart?
Explain what are non-additive facts?
What are algorithms provided by Microsoft in SQL Server?
What is cfapplication tag?
Where the data cube technology is used?