if source contain 10records how you identify header and footer
Answers were Sorted based on User's Feedback
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 |
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 |
Explain Association algorithm in Data mining?
Explain how to export mappings to the production environment?
What are aggregate fact tables ? why they are needed? give an example
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain what are the tasks that loadmanger process will do?
Explain what is fact less fact table? Where you have used it in your project?
What is MDX?
What is the purpose of cluster analysis in data warehousing?
Store (and count) non-fact records?
What is ETL process in Data warehousing?
what is the difference between DSS and ODS ?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?