Dynamic entities allow you to work with a limited but helpful set of dynamic entity metadata to analyze your data. You can drill down to see all the data in source file, then create and run entity business rules (EBRs) against dynamic entities to view passing and failing row results.
Here is a profiling process workflow using dynamic entities:
Create a dynamic entity that links directly to your data source.
Examine data rows and drill down to details for further investigation.
Create entity business rules and run them against the data. Drill down to see passing and failing rows.
Determine which rows and attributes you might want to load into a repository for full analysis.