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