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

What are the design methods of data warehousing?

0 Answers  


How to create diff. Types of templates?

0 Answers  


Explain the difference between view and materialized view?

0 Answers  


Explain what are components of reportnet?

0 Answers  


Can you pass sql queries in filter transformation?

0 Answers  






what are different types of partitioning in oracle ?

3 Answers  


how to calculate sum(sal) with out using aggregator satge

3 Answers   HSBC,


Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

0 Answers  


what is the diffrence between psa and idoc

0 Answers   iGate,


What is "method/1"?

0 Answers  


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

0 Answers  


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

0 Answers   TCS,


Categories