What is the difference between OLTP and ODS?

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


Please Help Members By Posting Answers For Below Questions

what are the deliverables?in your project?

1664


What is an expression transformation?

594


What is a rank transform?

678


What is mapping debugger?

574


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1632






What is the need of etl tools?

615


can anyone suggest best free Talend data integration training online

1263


What are the types of presistent cache in look up tr.

1551


What are the new features of informatica 9.x in developer level?

568


What does role playing dimension mean?

630


How can informatica be used for an organization?

653


What is informatica etl tool?

556


How to create Target definition for flat files?

756


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

555


How are indexes created after completing the load process?

989