Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / edh
I've got a web application used for creating product orders
backed by an RDBMS.
The RDBMS contains the necessary tables to store the facts
(orders and orderlines) and reference data (product, vendor,
price, customer, ...).
The RDBMS is ever growing. That is, there's no cleanup of
"old" records (e.g. orders from x years back).
What kind of database is this and why ?
An OLTP, an OLAP, an ODS, ..., something else ?
Please advise.
EDH
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the meaning of decode in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the reusable transformations?
which one is better performance wise joiner or look up
What are the different ways to implement parallel processing in informatica?
What are the features of complex mapping?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the size of your data warehousing?
Clarify the aggregator change?
What is the use of target designer?
Explain Dataware house architecture .how data flow from intial to end?
Parameter and variable differences
Can we create multiple integration service on single repository?
What is different between the data warehouse and data mart?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
