Hiwhat is difference betweend ETL and ELT?

  • Interview Candidate
  • 2
  • 2280

Showing Answers 1 - 2 of 2 Answers

jpg1dmg

  • Sep 26th, 2006
 

ETL usually scrubs the data then loads into the Datamart or Data Warehouse where as ELT Loads the data then use the RDMBS to scrub and reload into the Datamart or Datawarehouse

ETL = Extract >>> Transform >>> Load

ELT = Extract >>> Load >>> Transform

  Was this answer useful?  Yes

sunil

  • Oct 18th, 2006
 

ETL-> transformation takes place in staging area

and in ELT-> transormation takes at either source side r target side............

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions