Tag: Flat FIles

Informatica – Working with Tab Delimited Flat Files Source : Tab delimited Flat file Target  : Oracle Table Create a target table, here its a oracle table with same layout as source file Start the job and review the session log, All 10 records were processed and loaded in to target. We are done, successfully… Continue reading Informatica – Working with Delimited Flat Files

Informatica – Importing Fixed Width Flat Files — Fixed-width flat files are byte-oriented (measured in bytes). — It can also be line sequential, which means each row ends with a newline character. — Use Flat File Wizard to create, move, or delete column breaks. — ‘Start Import At Row’ Indicates the row number at which… Continue reading Informatica – Working with Fixed Width Flat Files