About Me

My photo
Northglenn, Colorado, United States
I'm primarily a BI Developer on the Microsoft stack. I do sometimes touch upon other Microsoft stacks ( web development, application development, and sql server development).
Showing posts with label positional. Show all posts
Showing posts with label positional. Show all posts

Monday, December 11, 2006

BizTalk Assessment Question: Make a schema from a postionial flat file

You are a Microsoft(R) BizTalk(R) Server 2006 application developer. You want to create a schema that is based on a positional document.

What should you do?

  • Purchase a third-party tool that converts positional documents to XML documents.
  • Count and record the starting position of each field.
  • Count and record the length of each field.
  • Count and record the ending position of each field.
  • Run the Flat File Wizard.
I think this one is kinda obvious, of course Microsoft is going to boast about the Flat File Wizard.

There are basically 3 types of flat files:
  • Delimited flat file.
  • Positional flat file.
  • A flat file with combination of Delimited and Positional records.