DSXchange

Hi ,

Which is the preffered or better File Format for Files . Is it Fixed Width or Delimited ..??

In my opinion there is no better file format.
Both can be used.

my preference goes to delimited format. the debugging is easier.

bart

It is like asking which is the better vehicle - a Porsche or a Chevy van. The answer will depend upon what you want to do with it.

Fixed width files are great for parallel processing (finding the 100th line is a simple matter of mutiplying line length times rows). This quick direct access is not possible with variable length files. Delimited files are smaller since there is no padding done and, as bart as already noted, they are easier to read manually.

The one which work better for the condition.

keshav0307 wrote:The one which work better for the codition.

I have no idea what "codition" means. Can you please clarify this term, ideally with a reference to a dictionary website or similar?

Meanwhile, from a perfomance perspective (and depending absolutely on how good the programmer is) I would prefer fixed width, because extracting/replacing fields is a simple substring (memory move) activity, whereas a delimited format necessitates a scan counting delimiters.

As a "hint" DataStage "remembers" the most recently encountered delimiter where the delimiters are @FM but not otherwise.

Ultimately, though, the best - and only - format for source files is the one that is right for the files "they" send to you.

very bad Ray. you don't have any idea.

That's why I quoted the entry before you edited it!

MS word has suggested word and auto correct option, can similar thing be implemented here, so that the typo error can be reduced.

Google Toolbar spell checker, that's what me use online. Too bad not grammar checker two.