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 does command task mean?
Explain the use of aggregator cache file?
Make a note of the quantity vaults made in informatica?
What are the components of workflow manager?
How do you change a non-reusable transformation to reusable transformation?
Write the unconnected lookup syntax and how to return more than one column.
Is there any way to read the ms excel datas directly into informatica?
What is sequence generator transformation in informatica?
explain about unit testing? in real time?
What is rank transformation?
What are the different clients of powercenter?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the different versions of informatica?