Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Fast Clone 11.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

Back Next

Configuring Miscellaneous Conditions

Configuring Miscellaneous Conditions

Optionally, you can set miscellaneous runtime parameters for data cloning. These parameters provide some important capabilities, such as writing output to pipes, encrypting passwords, compressing data, and configuring advanced settings for the Fast Clone executable.
  1. Click the
    Runtime Settings
     tab >
    Miscellaneous Conditions
     view.
    The following image shows this view:
  2. Enter information in any of the fields or accept the default values.
    The following table describes the fields in the
    Miscellaneous Conditions
     view:
    Field
    Description
    Default
    Dirty read
    If you use the direct path unload method, clear this option to lock the source tables for unload processing. When the tables are locked, Fast Clone can perform a consistent read.
    By default, this option is selected and Fast Clone does not lock the source tables during unload processing. Fast Clone bypasses this Oracle consistency mechanism. However, Fast Clone preserves block-level consistency because block
    I/O
     operations are atomic.
    Selected
    Consistent lock on table set
    If you use the direct path unload method and cleared the
    Dirty read
     option, select this option to lock all of the selected source tables in a table set before unloading the source data and to unlock these tables after unloading data from all of them. By default, this option is not selected and Fast Clone holds a lock on each source table only while unloading data from the table.
    Not selected
    Export by partitions when all selected
    If you unload data from partitioned source tables, indicates whether to write the data from each table partition to a separate output data file.
    On the
    Source Table Partitions
     tab, you can override this setting for individual source tables.
    To generate an output data file for each table partition, select this option. Then, on the
    Source Table Partitions
     tab, select each partitioned source table and verify that the
    Export table by partition
     check box is selected.
    Not selected
    Create output as pipes instead files
    Select this option to write output to a pipe instead of to a file system. Use this parameter for integration with other systems or scripts. Fast Clone creates a pipe file for each table prior to unloading table data.
    If you created a pipe file manually before unloading data, clear this option to have Fast Clone use the existing pipe file.
    Not selected
    Use SID instead of service name
    Select this option to use the Oracle SID instead of the SERVICE_NAME when you cannot connect to the source instance by using the instance name.
    Not selected
    Skip unreadable blocks
    If you use the direct path unload method, select this option to skip blocks that Fast Clone cannot read from Oracle data files and continue unload processing.
    By default, this option is not selected. When Fast Clone encounters a block it cannot read, it ends with an error and stops unload processing.
    Not selected
    Print column names
    If you unload data to an ASCII flat file, select this option to have Fast Clone write column names in the first row of the output files.
    By default, this option is not selected and Fast Clone does not write column names in the first row.
    Not selected
    Encrypt database passwords
    Indicates whether to encrypt database passwords in configuration files. Fast Clone applies the XOR operator to a password value by using the encryption key. Fast Clone then encrypts the resulting value by using the Base64 encryption schema.
    By default, this option is selected and database passwords are encrypted. Clear this option if you do not want to use encrypted passwords.
    Selected
    Extract long raw as HEX
    For Oracle targets, select this option to unload BLOB and LONG RAW source data in hexadecimal format. For other target types, clear this option to avoid generating incorrect control files.
    Not selected
    Direct select from sys
    Indicates whether to use SYS-owned dictionary tables, such as sys.obj$ and sys.tab$, to get Oracle extent boundaries. By default, Fast Clone uses SYS-owned dictionary tables to get extent boundaries. If you clear this option, Fast Clone uses the dba_extents and dba_segments views to get extent boundaries.
    For Oracle sources that use locally managed tablespaces, selecting data from the dba_extents view is slow. If the dictionary is partially analyzed and the optimizer mode is not RULE, selecting data from the dba_extent view might be very slow. Informatica recommends that you grant SELECT ANY DICTIONARY permissions to the user and use the default value for this option.
    Selected
    Read SECUREFILE by direct
    For Oracle 11
    g
     and 12
    c
     sources, indicates whether to use the direct path unload method to unload data from SecureFile LOB columns. For Oracle 12
    c
     sources, indicates whether to use the direct path unload method to unload data from extended NVARCHAR2, RAW, and VARCHAR2 columns. Clear this option to use the conventional path unload method to unload data from SecureFile LOB and extended datatype columns.
    Selected
    Character Set
    If you unload data to a Teradata target by using the direct path unload method, indicates whether to convert the source character data to UTF-8. The default value is NONE, which causes Fast Clone to preserve the source database encoding.
    NONE
    Read OCFS Direct
    For Oracle RAC sources on an Oracle Cluster File System (OCFS) on Linux or UNIX, indicates whether Fast Clone uses the direct
    I/O
     mode to read Oracle data files. The direct I/O mode minimizes the effects of the cache on reading data from Oracle data files. Select this option if the Oracle data files are located on an OCFS.
    Not selected
    Write OCFS Direct
    For Oracle RAC sources on an OCFS on Linux or UNIX, indicates whether Fast Clone uses the direct
    I/O
     mode to write the output files. The direct I/O mode minimizes the effects of the cache on writing the output files. Select this option if you configured Fast Clone to generate the output files on an OCFS.
    Not selected
    Compress data at unload time
    Indicates whether to compress the output data files during unload processing to reduce the file size.
    Not selected
    Data compression
    If you selected
    Compress data at unload time
    , select the compression method that Fast Clone uses to compress data. Options are:
    • GZIP
      . Provides a better compression ratio but is slower.
    • QZIP
      . Provides a lower compression ratio but is faster.
    GZIP
    GZIP compression level
    If you selected GZIP as the data compression method, enter the compression level. Valid values are 1 to 9. Higher values provide faster compression with a lower compression ratio. Lower values provide slower compression with a higher compression ratio.
    1
    Compress network traffic
    Select this option to compress network traffic between source and target servers when creating Fast Clone files on a remote server and using a Fast Clone Server.
    Selected
    Create external table script
    For Oracle targets, select this option to generate an SQL script for creating Oracle external tables based on the output data files.
    Not selected
    Create external table log file
    For Oracle targets, if you selected the
    Create external table script
     option, indicate whether to use a log file. If you select this option, the external table utility logs messages to this file when accessing data in the data file.
    Not selected
    External table name includes partition
    For Oracle targets, if you selected the
    Create external table script
     option, indicate whether the Oracle external table names include partition names in the output SQL script. Select this option to append partition names to external table names.
    Not selected
    Show progress in increments
    The number of rows that determines the frequency at which Fast Clone updates progress information when a data unload job is running. Each time Fast Clone finishes processing the specified number of rows, Fast Clone updates progress information.
    100000
    Perform checkpoint every
    The number of tables that determines the frequency with which Fast Clone performs checkpoints on the source database. Each time Fast Clone completes unloading the specified number of tables, Fast Clone performs a checkpoint on the source.
    Frequent checkpoints can increase the overhead of unload processing on the source system and might degrade unload performance.
    With the default value of 0, Fast Clone performs a checkpoint only prior to starting the data unload job.
    0
    Limit result set to
    Select this option to specify the maximum number of rows that Fast Clone can unload from each table. Valid values are -1 to 1073741823.
    By default, this option is not selected and Fast Clone uses the value of -1 to unload all of the rows from each table.
    Not selected
0 COMMENTS
We’d like to hear from you!