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 difference between writing a joiner query in ANSI style and THETA style?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Scheduling properties,whats the default (sequential)
Define pmcmd command?
What is fact table? Explain the different kinds of facts.
What is a grid in Informatica?
What are Dimensional table?
how to create user defined function (udf) in informatica
What is a repository manager?
Explain sessions. Explain how batches are used to combine executions?
What is the difference between router and filter?
What is target designer and target load order?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the different lookup cache(s)?
