Is there any model difference between ODS and DWH
Answers were Sorted based on User's Feedback
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 |
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 |
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
How to recover sessions in concurrent batches?
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
what we require for D.modelling?
What are the databases that informatica can connect to windows?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
List the transformation in informatica.
Could you explain what is enterprise data warehouse?
what happens if you try to create a shortcut to a non- shared folder?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
What is an incremental loading? in which situations we will use incremental loading
Explain the aggregator transformation?