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
How can you clear the cache?
What is analytical or analytic mean?
Why denormalization is promoted in universe designing?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is scd1 , scd2 , scd3?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is the difference between connected and unconnected stored procedures?
List down some of the real time data-warehousing tools?
What is degenerate dimension table?
The same tier?
What is the difference between view filter and report filter?
What is a general purpose scheduling tool?
What is difference between model & package?
What are the different models used in cluster analysis?
What should I have in mind when building olap solution from scratch?