Download SCT Banner Technical Student Technical Training Workbook
Transcript
Section Q: Conversion Lesson: Layout 210009506Abbe 610009711Abbot 210009101Adams 610009101Adams 710000011Adams 210009619Barker 210009613Barker Conversion Example: Flat File Layout Anthony PO Box 21049 Malvern PA19355226-MAR-77 James PO Box 27 Malvern PA19355217-NOV-79 Andrew 803 King Street Malvern PA19355210-DEC-72 Anthony 20789 Lancaster Ln Clarksville PA15122210-DEC-74 Eugene 3400 Wendrow Way University ParkPA16802201-JAN-01 Clementine 83 Park Avenue New York NY10013128-APR-72 James 854 Charlestown Pk King of PrussiaPA19401201-DEC-77 This layout is in columns, although comma delimited or quotation mark delimited can be used with SQL*LOADER (see manual for more information.) © SunGard 2004-2005 Student Technical Page 243