面试题与答案

Static cache is populated at the beginning of a session and does not change during the session, while dynamic cache can be updated during the session.

Constraint-based loading order in Informatica ensures that data is loaded into the target in a specific order based on defined constraints between transformations.

Incremental Aggregation in Informatica involves updating only the changed or new records in the source, reducing the processing load.

A Dynamic Lookup Cache in Informatica is created at runtime and allows the addition of new entries during the session.

A Persistent Cache in Informatica is a type of cache that is stored on disk and can be reused across sessions, providing improved performance.

In a Data-driven session in Informatica, the session properties and mappings are determined at runtime based on metadata, allowing dynamic control of the ETL process.

The Unconnected Stored Procedure transformation in Informatica is used to execute stored procedures that are not connected to the pipeline and do not return a value.

Dynamic Partitioning in Informatica allows the Informatica server to dynamically determine the number of partitions based on the available system resources.

A Lookup Override in Informatica allows you to override the default SQL query generated by the Lookup transformation to customize data retrieval.

A Source Filter in Informatica is used to filter rows at the source database level before they are read by the source qualifier, optimizing data extraction.