Dynamic grouping

来源:互联网 发布:perl dbd mysql 下载 编辑:程序博客网 时间:2024/06/06 02:07

Template is as below:

1. File header is having some constant value.
2. Batch Header (Department) contains department name , batch id (dynamically generated - previous batch id + 1)  + sum of salary of the 
      specific department.
3. Batch Detail are unique record for each employee.
4. Batch Trailer contains total number of employee of the specific department.
5. File Trailer contains total number of batches + overall salary of all the employees


Emp_Dept_File_Header
Department_Development3000
Ganesh1000
Sam2000
Total no of records in this batch is 2
Department_Testing6000
Shong3000
Tom2000
Andrea1000
Total no of records in this batch is 3
Total no of batches in the file is 2 and overall salary is 9000
 

原创粉丝点击