Final answer:
To determine the failed records when loading data with internal key generation, review the log files or systems reports, which should detail the errors. Look for specific error messages or codes to identify problems and use available tools or interfaces to analyze and correct the records.
Step-by-step explanation:
When loading data with internal key generation into a target system, records may fail to load for various reasons, including data validation errors, format issues, or system constraints. To determine the failed records, you often need to consult the log files, which are typically generated during the data load process. These logs should contain information about each record that failed and the reason for its failure.
Most systems provide a detailed error message or error code that you can use to identify the problem. For example, if the target is a database, you could look for SQL error codes in your logs. Alternatively, the loading process may provide a summary report at the end, indicating the success and failure counts, along with a way to extract the specific failed records for further analysis.
Depending on the tools and software used, you may also have a dashboard or an interface that allows you to filter and view failed records interactively. This can be particularly handy if the tool supports retry mechanisms for loading the failed records after you correct the underlying issue. The key is to thoroughly review the provided information and utilize the available tools to pinpoint and rectify the issues causing the record failures.