Is there any model difference between ODS and DWH
- 2 Answers
- 6123 Views
- Zensar, I also Faced
- E-Mail Answers
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 pmcmd command?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain incremental aggregation in informatica
wat are deployement groups in informatica, how it will be used for developers
What are the advantages of using informatica as an etl tool over teradata?
How is union transformation utilized?
What are the issues you have faced in your project? How did you overcome those issues?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the popular informatica products?
Design a mapping to load a target table with the following values from the above source?
What do you understand by term role-playing dimension?
what is informatica metadata?
Could you explain what is enterprise data warehouse?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Define joiner transformation?
