Is there any model difference between ODS and DWH
- 2 Answers
- 6124 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
To import the flat file definition into the designer where should the flat file be placed?
Explain the different dimensions.
How can one identify whether mapping is correct or not without connecting session?
What is update strategy transform?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how many types of dimensions are available in informatica?
How we can use union transformation?
Why sorter is an active transformation?
What is event and what are the tasks related to it?
tell me the rules and responsblites in our project(my project is development)
What are the different clients of powercenter?
How to elaborate powercenter integration service?
What is a joiner transformation?
Where is metadata stored?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
