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 |
How to export mappings to the production environment?
What is the difference between datawarehouse and bi?
Compare and contrast aggregates & indexes
What is analytical or analytic mean?
Fact table is in normalized or de-normalized form?
Explain in simple terms, the concept of Data Mining.
What is cost benefit analysis (cba)?
What is conformed fact?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is defined as partial backup?