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).

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.

No comments: