Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the optimized method of extracting the data.
- 3 Answers
- 7349 Views
- I also Faced
- E-Mail Answers
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 would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is metadata in context of a datawarehouse and how it is important?
Data WareHousing course in noida
How can we schedule the graph in unix?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are the different types of Fatcs? Explain with example only
Do you view contain data?
Explain where do we use semi and non additive facts?
What are different deliverables according to phases?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What are the steps involved in designing a fact table?
Teradata 
