Interested to Buy Any Domain ? << Click Here >> for more details...
what is an ETL or ETT? And what are the different types?
- 1 Answers
- 7582 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What do you understand by the term ‘transformation’?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Can there be sub steps of etl steps?
what is SMP AND MPP?
without using ETL tool can u prepare a Data warehousing and maintaining?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
what is pmrep command?
What is the difference between Data Warehousing and Data Mining?
What is fact? What are the types of facts?
what are the reporting tools and difference between them?
what is the difference between cubes and package in cognos
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
Teradata 
