Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any model difference between ODS and DWH
- 2 Answers
- 7195 Views
- Zensar, I also Faced
- E-Mail Answers
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 |
scenario where i can use only concurrent execution of workflow.
How do you load unique records into one target table and duplicate records into a different target table?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain the different lookup methods used in informatica?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
How to join three sources using joiner?
What are Target Options on the Servers?
What is decode in static cache?
What are the types of presistent cache in look up tr.
What are the different transaction levels available in transaction control transformation?
What is the default source option for update stratgey transformation?
how can one come to know wether the records loak into the target if we use update strategy
Teradata 
