Describe a problem that occurs when you parse a complex flat file in BizTalk Server 2004 with the parser_optimization property set to the default valu

Special Thanks to...
http://sandeepshewale.spaces.live.com/blog/cns!597AD44E67439214!212.entry
which in turn takes to this site.
http://kbalertz.com/884622/Parsing-complex-BizTalk-Server.aspx

Parsing a complex flat file may fail in BizTalk Server 2006 and in BizTalk Server 2004

SYMPTOMS
When you try to parse a complex flat file in Microsoft BizTalk Server 2006 or in Microsoft BizTalk Server 2004, the parser may fail, and you may receive an error message that is similar to one of the following error messages:
Error message 1
Unexpected Data Found while looking for ElementName

Error message 2
Unable to match the data in the input stream

CAUSE
This problem may occur when the parser_optimization property is set to the default value of "speed" in the schema. Additionally, if you have many optional nodes in the same group or record, the lookahead_depth property may not be set correctly.

RESOLUTION
To resolve this problem, set the parser_optimization property to "complexity" and the lookahead_depth property to "0" (zero) in the schema. The parser_optimization property and the lookahead_depth property are not present in the user interface. You must manually change the properties in the schemaInfo element, as in the following example:

complexity" lookahead_depth="0"/>

MORE INFORMATION

BizTalk Server has the following two modes for the algorithm to parse a flat file into XML:
"speed" "complexity"By default, the setting for the parser_optimization property is "speed." This setting is optimized to decrease parsing time. The "speed" setting can handle most flat files but cannot deal with all the ambiguities that the "complexity" setting can. The "complexity" mode is not quick but can handle a wider range of ambiguities.There are five properties that cannot be changed in the BizTalk Server 2004 user interface. The following table lists the flat file node properties:
Collapse this tableExpand this table


Property
Values
Default value
Description
suppress_empty_nodes
true or false
false
Indicates whether to remove empty XML nodes after the parser generates XML instance data.
generate_empty_nodes
true or false
true
Generates empty nodes for records that exist in the XML instance data.
parser_optimization
speed or complexity
speed
Optimizing for speed decreases the parsing time at the cost of dealing with some ambiguities in data. Optimizing for complexity handles a wider range of ambiguities at the cost of processing speed.
lookahead_depth
Any positive integer. A value of 0 (zero) indicates infinite lookahead.
3
Indicates how far to look ahead for matching data.
allow_early_termination
true or false
false
Indicates whether positional records can terminate early (true) or must contain data for all record fields (false).Note If you set the allow_early_termination property to true, early termination of a positional record is permitted in cases where the right-most or outermost field is less than its defined length.

7-S Model

A Managerial Tool for Analyzing and Improving Organizations

[eMBA] Data Management - Confidence Intervals

 

This is a good example of sample data could lead to uncertain results.

We discussed how to  use Crystal Ball and it's Forecast.

Learn more about the Confidence Function in Excel 2007

How to use "Fit" in Crystal Ball's  "Define Assumptions" to determine best fit for the current dataset.

[KB] How Oil Sand Projects Work?

These Videos will help you to understand how OilSand Projects in Canada [Fort McMurray, Alberta] are executed.

Interesting Videos make it easy to understand. [Broken Links Will Update with new links soon.]

[eMBA] Marketing Analysis

Competitive Analysis :- Compare yourself with your competitors

Trend Analysis :- for technology, Demographic, Natural , Legal / Political, Cultural , Economic

Market Analysis:- Analysis of Customer trend

Eg. What you do with your Cherios?

Eat

Silent Kid

Toilet aiming

Play Poker

Crafts

Decorate Christmas tree

---------------------------------------------------------------------------------

If I have to make your decision then I don't need you.

Target Problems …. Not symptoms

In common parlance, a devil's advocate is someone who takes a position, sometimes one he or she disagrees with, for the sake of argument. This process can be used to test the quality of the original argument and identify weaknesses in its structure.

Pasted from <http://en.wikipedia.org/wiki/Advocatus_diaboli>

[KB] Find and Read

Friends, I am willing to read and understand more about this...
Any links, suggestions will be admired.

Six Sigma Model
ISO

[eMBA] TreePlan and Precision Tree for Excel

(For Data Analysis and Modeling)

These are the decision tree and charting software which will help you to plot decision trees in Excel

TreePlan
TreePlan helps you build a decision tree diagram in an Excel worksheet using dialog boxes. Decision trees are useful for analyzing sequential decision problems under uncertainty. TreePlan automatically includes formulas for summing cash flows to obtain outcome values and for calculating rollback values for determining optimal strategy.

PrecisionTree
PrecisionTree performs decision analysis in Microsoft Excel using decision trees and influence diagrams. Decision trees let you visually map out complex, multi-layered decisions in a sequential, organized manner. This helps you identify all possible alternatives and choose the best option.

Simple Tornado Chart
A tornado chart is a bar chart commonly used to compare characteristics of two populations.

DataTable
There are two types of Data Tables
(1 way Data Table & 2 Way Data Table)