Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7464 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
can be used COM component in Informatica ?
Two default user groups created in the repository are____and_____.
How many steps etl contains?
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 are the reporting tools and difference between them?
what is the difference between cardinality and Nullability?
When do we analyze the tables? How do we do it?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how would u estimate the size of Lookup transform data and index cache?
What is fact? What are the types of facts?
What is full load & incremental or refresh load?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Explain what is etl process? How many steps etl contains explain with example?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
How to fine tune mappings?
