Is there any model difference between ODS and DWH

Answers were Sorted based on User's Feedback



Is there any model difference between ODS and DWH..

Answer / bharu_295

ODS is a Replica of transactional data so it is OLTP and DW is an HIstorical Data so its OLAP.

Is This Answer Correct ?    5 Yes 0 No

Is there any model difference between ODS and DWH..

Answer / vchandra

ODS stores operational data where as DWH store ODS data as
well as the history of the source database

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,


How to recover sessions in concurrent batches?

1 Answers  


i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,


what we require for D.modelling?

1 Answers  


What are the databases that informatica can connect to windows?

0 Answers  






What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


List the transformation in informatica.

1 Answers   TCS,


Could you explain what is enterprise data warehouse?

0 Answers  


what happens if you try to create a shortcut to a non- shared folder?

1 Answers  


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,


Explain the aggregator transformation?

0 Answers  


Categories