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 […]
Read MoreTag: Flat FIles
Informatica – Working with Fixed Width 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 […]
Read More