Answer Posted / harshad
Data purging is nothing but deleting your data from DW.
Sometimes While loading data into staging or target table
you may need to load fresh data everytimes (called full
load). In this case you need to purge the complete
stage/target table before load it with Fresh data.
Pls point me if I'm worng.
| Is This Answer Correct ? | 102 Yes | 12 No |
Post New Answer View All Answers
Where the data cube technology is used?
what are relationships?
what type of raid setup would you put your tx logs?
List down some of the real time data-warehousing tools?
Why should we use data ware housing and how can you extract data for analysis with example?
What are the various file formats involved in reportnet?
Explain what is ods (operation data source)?
How can we schedule the graph in unix?
Explain can report net connect multiple datasource at a time in report creation time?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What are the key columns in Fact and dimension tables?
What are non-additive facts in detail?
Why is chameleon method used in data warehouse?
What are the various transformation available?
Explain what are slowly changing dimensions?