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 |
What is a shortcut and copy in Informatica and how two are different with each other?
when we dont use aggregator in mapping ?
Filter transformation in the condition one of the data is NULL would the record be dropped.
performance wise which one is better in joiner and lookup transformation
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is the difference between unicode & ascii mode data movement in informatica?
What are the different tools in workflow manager?
What is workflow? What are the components of the workflow manager?
What is informatica powercenter repository?
How to load time dimension?
How can you access the remote source into your session?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?