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

Target Database Parameters

Target Database Parameters

Specify the following command line parameters to connect to the source database:
destination_database_type
The target database type. Options are:
  • flat
    . Use this option for flat file targets.
  • greenplum3
    . Use this option for Greenplum targets.
  • cloudera
    . Use this option for Cloudera targets.
  • hive
    . Use this option for Hive targets.
  • hortonworks
    . Use this option for Hortonworks targets.
  • mssql
    . Use this option for Microsoft SQL Server targets.
  • netezza
    . Use this option for Netezza targets.
  • oracle
    . Use this option for Oracle targets.
  • teradata
    . Use this option for Teradata targets.
  • vertica
    . Use this option for Vertica targets.
Default value: oracle
destination_host
The host name or IP address of the system where the target database runs.
destination_instance
The target instance name or database name for the tables to be loaded.
destination_load_batchsize
The number of rows in a batch that is passed to the Microsoft SQL Server osql utility for loading data to the target. The osql utility copies each batch to the target server as one transaction.
Fast Clone uses this value as the BATCHSIZE option value in the BULK INSERT statement for the osql utility.
Range of values: 1 through 1000000
Default value: 10000
destination_load_maxerrors
For Greenplum and Teradata targets, the maximum number of errors that can occur when streaming data to the target database with DataStreamer. If the number of errors exceeds this maximum, DataStreamer ends with an error.
For Microsoft SQL Server targets, specifies the maximum number of syntax errors that can appear in the output data files before the osql utility cancels the BULK INSERT operation. The osql utility ignores all of the rows that it cannot parse and counts an error for each row. Fast Clone uses this value as the MAXERRORS option value in the BULK INSERT statement for the osql utility.
Range of values: 1 through 1000000
Default value: 100000
destination_password
A valid password for the user that is specified by the
destination_user
 parameter. If you specify a forward slash (/) in the
destination_user
 parameter, Fast Clone ignores the password and uses operating system authentication
destination_port
The port number that Fast Clone uses to connect to the target database.
Default value: No default value is provided.
destination_schema
The target schema name or schema owner for the tables to be loaded.
destination_user
The name of a user who has permissions to connect to the target database and load the source data. If you specify a forward slash (/) in this parameter, Fast Clone ignores the password and uses operating system authentication.
greenplum_loader_home
For Greenplum targets, if you load data to the target database from data files or pipes, the path to the Greenplum loader root directory that Fast Clone uses to locate the gpload utility and generate valid load scripts.
0 COMMENTS
We’d like to hear from you!