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 can you define a transformation? What are different types of transformations in Informatica?
What is multi-dimensional analysis?
I know of using applysimple, but there are other ways too?
Explain what are the different types of data warehousing?
What are the differences between datamart vs. Reporting cube?
where exactly in dataware house a confirmed dimension can be created
What is a functional dependency f said to be minimal?
Explain what is a cube in data warehousing concept?
Compare ?Data mining? and ?Data Warehousing??
Explain the different types of data warehousing?
What is the capacity of power cube?
What are session timeout and application timeout?