Question: Explain the difference between ETL and ELT.Answer: ETL (Extract, Transform, Load) is a process where data is extracted from source systems, transformed, and then loaded into a data warehouse. ELT (Extract, Load, Transform) is a process where data is first extracted and loaded into the target system, and then transformations are applied. |
Save For Revision
Bookmark this item, mark it difficult, or place it in a revision set.
Log in to save bookmarks, difficult questions, and revision sets.
Is it helpful? Yes No
Most helpful rated by users:
- What is Informatica PowerCenter?
- What is a Repository Service in Informatica?
- Explain the concept of a Source Filter in Informatica.
- What is a Lookup Override in Informatica?
- What is a Session in Informatica?