if source contain 10records how you identify header and footer

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

Why should we use data ware housing and how can you extract data for analysis with example?

0 Answers   TCS,


How to calculate fact table granularity?

0 Answers  


what type of raid setup would you put your tx logs?

0 Answers  


What are the different ways to represent the loading of dimension tables?

0 Answers  


What is Analysis Services?

0 Answers  






Where the applications and where

0 Answers  


What is META DATA information in Data warehousing projects?

2 Answers   IBM,


What is normalization, first normal form, second normal form, third normal form?

0 Answers  


what is query optimizer? what are different types of optimizer s supported by oracle ?

1 Answers   ABC,


What is execution plan?

0 Answers  


What do you mean by static and local variable?

0 Answers  


How can you clear the cache?

0 Answers  


Categories