This section provides step-by-step instructions on all the approaches to load structured data into Greenplum Database (ELT using external tables) and any unstructured data into HD using proprietary utilities within Greenplum distribution. Additionally, for Greenplum Database, we will also look at options to integrate with an external ETL tool like Informatica PowerCenter using a specialized connecter called PowerExchange(PWX) connector.
Data can be loaded, transformed, and formatted in Greenplum using in-built utilities and tools. There are the options that load data into Greenplum in parallel or sequential form. The following are the different ways to load data into Greenplum Database: