Is there any model difference between ODS and DWH
- 2 Answers
- 6116 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 |
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
What are the types of caches in lookup? Explain them.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
What is the status code?
What is intricate mapping?
what is the difference between informatica6.1 and infomatica7.1
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
my source is junk data how will u remove that junk data by using unix please any one replay me
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
explan ur project architecture?
difference between repository database and repository service?
Teradata 
