Interested to Buy Any Domain ? << Click Here >> for more details...
what is an ETL or ETT? And what are the different types?
- 1 Answers
- 7580 Views
- I also Faced
- E-Mail Answers
Answer Posted / Amar
ETL (Extract, Transform, Load) and ETT (Extract, Transform, Transport) are data integration processes used to move data from various sources into a target system. While ETL permanently loads data into the target system, ETT moves data temporarily for further processing or analysis:
1. Type I ETL: Uses batch processing to extract, transform, and load data in bulk.
2. Type II ETL: Updates the target system by comparing source and target data and applying necessary changes.
3. Type III ETL: Continuously captures and processes data changes as they occur in real-time or near-real-time (streaming ETL).
4. ELT (Extract, Load, Transform): A variation of ETL where raw data is initially loaded into the target system without initial transformations, and then transformed later.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
what are the data modeling tools you have used?(polaris)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
