1,126
edits
(A variety of small changes, addition of the paragraph about data validation.) |
|||
| Line 115: | Line 115: | ||
Write your report files with the following prefix: ApplicationGroup.DateFormat.Application | Write your report files with the following prefix: ApplicationGroup.DateFormat.Application | ||
This will allow you to load by Application Group, Date, and Application easily when you sort the files. By having the date as your second 'field' in the file name, you make loading in Chronological order easy and straightforward. | This will allow you to load by Application Group, Date, and Application easily when you sort the files. By having the date as your second 'field' in the file name, you make loading in Chronological order easy and straightforward. Regardless of your locale, using the YYYY-MM-DD format (with leading zeros) is wise, as most UNIX/Linux operating systems will natively sort file lists (like ls, or wildcards like "*" -- but not the 'find' command which outputs data in the order they appear in the filesystems inodes) which optimizes the way database tables for each individual App Group (known as 'segment tables' in CMOD lingo) are created. | ||
=== Concatenate Reports === | === Concatenate Reports === | ||