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
Explain what are slowly changing dimensions?
What are the tools available for etl?
Explain functional dependency?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain swot analysis?
How to limit the max no of rows retrieved in the report?
Why null values are mapped as 0 in fact tables?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain reference cursor?
How can you set the client management?
What are snapshots? What are materialized views & where do we use them?
Explain the hierarchies level data warehousing.
What are the different types of join operations?
What is index awareness in universe?
What are non-additive facts in detail?
