Is there any model difference between ODS and DWH
- 2 Answers
- 6614 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
How do you migrate data from one environment to another?
Reusable transformation and shortcut differences
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the performance considerations when working with aggregator transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is blocking transformation?
how tokens will generate?
What are the tasks that source qualifier perform?
How can you increase the performance in joiner transformation?
What can we do to improve the performance of informatica aggregator transformation?
What is the function of aggregator transformation?
Have you worked with/created Parameter file
What is confirmed fact in dataware housing?
Please let me know how to make Data masking in informatica..
