Which is the optimized method of extracting the data.
Answers were Sorted based on User's Feedback
Answer / pratap gangula
Delta loading is a way to extract data in a optimized way. Doing the incremental load by tracking the last update date or modified date makes the ETL processing faster.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / aswin
break-down the data into small chunks and try to process it...if it flatfile use unix to split the file
if it is oracle, use external table concept and load it into partitioned table using swap partition
Is This Answer Correct ? | 0 Yes | 0 No |
What are snapshots? What are materialized views & where do we use them?
What is surrogate key? Explain with examples.
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What does level of granularity of a fact table signify?
What are the various transformation available?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
What are the tools available for etl?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain difference between e-r modeling and dimentional modeling?
in general which algorithms for used?
Explain what is batch and describe about types of batches?