Network
Data Engineering
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Preparation
Cloud Integration
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
DiscoveryIQ
Cloud Data Wizard
Informatica for AWS
Informatica for Microsoft
Cloud Integration Hub
Complex Event Processing
Proactive Healthcare Decision Management
Proactive Monitoring
Real-Time Alert Manager
Rule Point
Data Integration
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Replication
Data Services
Data Validation Option
Fast Clone
Informatica Platform
Metadata Manager
PowerCenter
PowerCenter Express
PowerExchange
PowerExchange Adapters
Data Quality
Axon Data Governance
Data as a Service
Data Explorer
Data Quality
Data Security Group (Formerly ILM)
Data Archive
Data Centric Security
Secure@Source
Secure Testing
Master Data Management
Identity Resolution
MDM - Relate 360
Multidomain MDM
MDM Registry Edition
Process Automation
ActiveVOS
Process Automation
Product Information Management
Informatica Procurement
MDM - Product 360
Ultra Messaging
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
Knowledge Base
Resources
PAM (Product Availability Matrices)
Support TV
Velocity (Best Practices)
Mapping Templates
Debugging Tools
User Groups
Documentation
English
English
English
Español
Spanish
Deutsch
German
Français
French
日本語
Japanese
한국어
Korean
Português
Portuguese
中文
Chinese
Log Out
Log In
Sign Up
Cloud Data Integration
Current Version
H2L
Current Version
Components
Cloud Data Integration
All Products
Table of Contents
Search
No Results
Preface
Components
Business services
Defining a business service
File listeners
File listeners in file ingestion tasks
File listeners in taskflows
File listeners in B2B Gateway partner flows
Behavioral differences in file listeners
Configuring a file listener
Configuring file listener for a server source type
Configuring file listener for a connector source type
Start and stop a file listener manually
Starting and stopping a file listener
Fixed-width file formats
Creating a fixed-width file format
Hierarchical schemas
Creating a hierarchical schema
Intelligent structure models
Using intelligent structure models in Data Integration mappings
Using intelligent structure models in Data Integration elastic mappings
Using intelligent structure models in Data Engineering Integration mappings
Intelligent Structure Discovery process
Sample files
Data drifts
Discovering a file structure and creating an intelligent structure model
Intelligent structure example
Refining a discovered structure
Navigating the output
Navigating the intelligent structure
Editing the nodes
Performing actions on data in nodes
Performing actions on multiple nodes
Enriching an existing intelligent structure with new samples
Document identifiers
Working with output groups
Repeating groups
Primary and foreign keys
Working with repeating groups
Editing an Intelligent Structure Model
Exporting an intelligent structure model
Deleting an Intelligent Structure Model
Troubleshooting intelligent structure models
Use Case
Mapplets
Active and passive mapplets
Mapplet Input and Output
Mapplet input
Mapplet output
Parameters in mapplets
Creating a mapplet
Editing a mapplet
Synchronizing a mapplet
Mapplets in Data Integration Elastic
Editing a mapplet in Data Integration Elastic
PowerCenter mapplets
Active and passive PowerCenter mapplets
Stored Procedures in mapplets
PowerCenter XML files for mapplets
PowerCenter mapplets in Data Integration tasks
Configuring a PowerCenter mapplet
Saved queries
Saved query syntax
Using saved queries in synchronization tasks
Using saved queries in SQL transformations
Configuring a saved query
Shared sequences
Shared sequence properties
Number of reserved values
Creating a shared sequence
Using a shared sequence
Resetting a shared sequence
User-defined functions
Creating user-defined functions
User-defined function general properties
User-defined function arguments
User-defined function expression
Editing and deleting user-defined functions
Creating expressions with user-defined functions
Components
Components
Back
Next
Using saved queries in synchronization tasks
Using saved queries in
synchronization
tasks
Use the following rules and guidelines to use a saved query in a
synchronization
task:
You can add one saved query to each
synchronization
task.
You cannot delete a saved query that is used in a
synchronization
task.
If you edit column information for a saved query, the
synchronization
task does not write error rows to the error rows file at runtime.
In the log details for the task, the success and error row counts for sources might not be accurate when you use a saved query.
When you use an active mapplet with a
synchronization
task that includes a saved query, the
synchronization
task inserts data to the target even if you select a different target option.
Saved queries
Updated January 22, 2021
Download Guide
Send Feedback
Explore Informatica Network
Communities
Knowledge Base
Success Portal
Back to Top
Back
Next