Which is the optimized method of extracting the data.
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is a cube in data warehousing concept?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what are fact, dimension, and measure?
What needs to be done while starting the database?
How are the dimension tables designed?
What is difference between model & package?
What are diagrams?
Is there any difference in testing database and data ware housing?
Is union transormation is active transformation?
How can you set the session management?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what are non-additive facts in detail?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Explain how many ways you create ports?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.