The IQ Loader File via Load Table component loads data from a file into a target IQ database using an automatically generated LOAD TABLE statement.
This self-contained component operates as a data source when it reads from source files and a data sink when it writes to a Sybase IQ database. It does not have IN and OUT-ports, therefore, there is no need to create one component for performing the read from the source file and another component for invoking Load Table in Sybase IQ. ETL automatically generates Load Table statements that extract data from a delimited text file and loads the data to Sybase IQ.