IQ Loader File via Load Table component loads data from a file into a target IQ database via an automatically generated LOAD TABLE statement.
This is a self contained component that operates as a data source when it reads from source files and a data sink when it writes to a Sybase IQ database. This component does not have input and output 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.