Is there any model difference between ODS and DWH
Answer Posted / 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 |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
While migrating the data from one environment to another environment how would you manage the connections?
Separate from an archive server and a powerhouse?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the meaning of decode in informatica?
Explain the difference between a data warehouse and a data mart?
How many transformations can be used in mapplets.
What is resilience time?
Design a mapping to load a target table with the following values from the above source?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is Data Caches size?
Which transformation should we use to normalise the COBOL and relational sources?
Explain the use of aggregator cache file?
Where is metadata stored?