Apr 27, 2013 The Complex Flat File stage supports multiple outputs. An output link specifies the data you are extracting, which is a stream of rows to be read. When using the Complex Flat File stage to process a large number of columns, for example, more than 300, use only one output link in your job. For example, For the Sequential file stage, we need to define the mandatory parameters like the file name, file location, column metadata. Then we need to compile the Datastage job. Compiling the job checks for the syntax of the job and creates an executable file for the Datastage job that can be executed at run time. Jul 10, 2018 It is one of many possible designs which can implement this dimension. The example is based on the customers load into a data warehouse Datastage SCD1 job design The most important facts and stages of the CUSTSCD2 job processing:. There is a hashed file (HashNewCust) which handles a lookup of the new data coming from the text file.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |