if source contain 10records how you identify header and footer

Question Posted / anuradha

2 Answers
6863 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if source contain 10records how you identify header and footer..

Answer / ankit kansal

The basic rules regarding any file states that a file first line must be a header and last row must be a footer for a particular file.

So while reading your data you can provide validation and can handle all the situations differently as per your business needs.

http://deepinopensource.blogspot.in

Is This Answer Correct ?

0 Yes

0 No

if source contain 10records how you identify header and footer..

Answer / guest

If a source file will have header and footer, then header record will start with 0, trailer record will start with 9 and the detailed record will start with 1.
so the first record starts with zero, next 8 records with 1 and the last record with a 9.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Warehouse General Interview Questions

what is indexing ? what are different types of indexes supported by oracle ?

2 Answers

What is vldb(very large databases)?

0 Answers

wht is degenerated dimension ?it's uses?

10 Answers CTS, Infosys,

what are the others of "bad files" and "discard files" when using sql*loader?