ETL or ELT? What is the best for Vertica Database?

mpedrosompedroso Registered User

Hey guys

I'm developing a DW using Vertica and would like to know which option would be best on Vertica. Do ETL (Extraction, transformation and load) or ELT (Extraction, loading and transformation within the Vertica)?

Hugs.

Best Answer

Answers

  • mpedrosompedroso Registered User

    Hi marcothesane,

    Many thanks for the reply. I was already thinking about working with ELT. Now, with your confirmation I'll implement it that way.

    Thank you very much.

  • mpedrosompedroso Registered User

    Hi marcothesane

    Thanks for answering my ETL or ELT question.

    I would like to take advantage of the contact and ask how the process of transforming and loading data in Vertica using the ELT process is done. I think I need to use two schemas, a "STAGE" to load my raw data and a "DW" schema to load the data already processed and following a multidimensional model. Would it be this?
    How could I automate the process of transforming and loading this data into Vertica? For this I could create a procedure?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file