Informatica – Working with Delimited Flat Files

Informatica – Working with Tab Delimited Flat Files

Source : Tab delimited Flat file
Target  : Oracle Table

delimited-file-from-excel
Here we are using a tab delimited source file created using excel, save the file as ‘Text(Tab_delimited)’
Informatica – Working with Delimited Flat Files
Tab Delimited Flat file source with first row as header
Informatica – Working with Delimited Flat Files-impor
Start the import from PowerCenter designer. Source >> ‘Import from file’
Working with Delimited Flat Files-wizard
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 2
Working with Delimited Flat Files wizard 2
Wizard 2 – select the delimiter as ‘Tab’ and make sure all the fields are populated correctly.
Working with Delimited Flat Files-wizard3
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.
Working with Delimited Flat Files-source-file
Now we have the source definition in source analyzer, edit and review the column information’s, also right click and preview the data.

Working with Delimited Flat Files-target-tableCreate a target table, here its a oracle table with same layout as source file

Working with Delimited Flat Files-mapping
Create a basic mapping, reading from source file and loading to target table.
Working with Delimited Flat Files-workflow
Create the workflow, edit & give the source file directory and target table connections.

Working with Delimited Flat Files-session-logStart the job and review the session log, All 10 records were processed and loaded in to target.

Working with Delimited Flat Files-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.

***

If you have any further questions, please do send an e-mail to kvtinformatica@gmail.com.

You May Also Like

About the Author: kvt

Leave a Reply

Your email address will not be published. Required fields are marked *