Source Qualifier transformation is an active and connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier Transformation. The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc.
Subscribe to:
Post Comments (Atom)
Snowflake - Cost Optimization
Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...
-
MD5 (Message Digest Function) is a hash function in Informatica which is used to evaluate data integrity. The MD5 function uses Message-Dig...
-
Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
-
Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
No comments:
Post a Comment