when the source is file where can we set the file properties.
-
session level
-
mapping level
-
worlflow level
-
none of the above
In Informatica PowerCenter, when the source is a file, file properties like source file name, directory path, and file type can be configured at the session level. Session properties override source qualifier settings and provide the most granular control for source file connections. Mapping and workflow levels don't handle these specific file properties.
When the source is a flat file in an ETL tool like Informatica, file-specific properties (such as file name, directory path, and file type) are configured at the session level, in the session's source properties, not in the mapping itself. The mapping level deals with transformation logic and data flow, not physical file location details.