Answer Posted / sri47
OLTP refers a transactional Data base.
ODS refers a data base which actually contains the Basic
data like the details of available Procts,and Branches of
Company etc.
Means It will be small in size and can be modified
daily.Most of the times Thos ODs is used for loading the
Dimensions.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain sessions. Explain how batches are used to combine executions?
How do you set a varible in incremental aggregation
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Enlist the differences between database and data warehouse.
Explain how to import oracle sequence into informatica?
How does a sorter cache works?
Differentiate between a database and data warehouse?
scenario where i can use only concurrent execution of workflow.
4 yrs etl devloper roles and responsibilities?any body give solutions
What all join we can perform in LOOKUP transformation?
How does the aggregator transformation handle null values?
r u done any partitions in ur project?
How you prepared reports for OLAP?
what is the size of u r source(like file or table)?
What are mapplets? How is it different from a Reusable Transformation?