Here we are using a tab delimited source file created using excel, save the file as ‘Text(Tab_delimited)’Tab Delimited Flat file source with first row as headerStart the import from PowerCenter designer. Source >> ‘Import from file’FF import Wizard 1 – since we have the header in the source file, Enable ‘Import field names from first line’ and start import from row 2Wizard 2 – select the delimiter as ‘Tab’ and make sure all the fields are populated correctly.Wizard 3 – Column information’s are automatically populated from the input header record, Review the datatype & length and correct it if anything is wrongly interpreted by wizard.Now we have the source definition in source analyzer, edit and review the column information’s, also right click and preview the data.
Create a target table, here its a oracle table with same layout as source file
Create a basic mapping, reading from source file and loading to target table.Create the workflow, edit & give the source file directory and target table connections.
Start the job and review the session log, All 10 records were processed and loaded in to target.
Review the data in the target table. All looks good here.
We are done, successfully imported and loaded tab delimited flat file to a target table. Here we just used a simple mapping without formatting anything on input data, We may need to do some kind of data validation before we process through the transformation and that we will see in the next post.
