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
What is depict expression change?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what is degenerated dimension?
Explain scd type 3 through mapping.
what is the size of your data warehousing?
Explain the different kinds of facts.
What are Dimensional table?
Explain the tuning lookup transformation - informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What does refresh system mean, and what are its distinctive choice?
Explain in detail scd type 2 through mapping.
What is the use of code page?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Which files are created during the session rums by informatics server?
Implementation methodology