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
Explain the shared cache and re-cache?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is expression transformation?
Explain constraint based loading in informatica
how we can load rejected record's at run time?(not through bad files)
What are the different transaction levels available in transaction control transformation?
In development project what is the process to follow for an etl developer from day1
What is main use of mapplet?
What is a router transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Mention few advantages of router transformation over filter transformation.
What is the difference between informatica 7.0 and 8.0?
without table how to come first record only in oracle?
