Informatica pmrep命令用法

管理powercenter 资料库

PMREP

Usage: pmrep run

                 -f <script_file_name>

                 [-o <output_file_name>]

                 [-e (echo commands)]

                 [-s (stop at first error)]

                 [-u (UTF-8 encoded script fileand output file)]

Usage: pmrep connect

                     -r <repository_name>

                     -d <domain_name>

                     -n <user_name>

                     -x <password>

                     [-t<client_resilience>]

Usage: pmrep create

                    -u <domain_user_name>

                    [-s<domain_user_security_domain>]

                    [-p <domain_password>|

                     -P<domain_password_environment_variable>]

                    [-g (create global repository)]

                    [-v (enable objectversioning)]

 

Usage: pmrep delete

                    [-x<repository_password_for_confirmation> |

                     -X<repository_password_environment_variable_for_confirmation>]

                    [-f (forceful delete:unregisters local repositories and deletes)]

 

Usage: pmrep upgrade

                     [-x<repository_password_for_confirmation> |

                      -X<repository_password_environment_variable_for_confirmation>]

 

Usage: pmrep restore

                     -u<domain_user_name>

                     [-s<domain_user_security_domain>]

                     [-p<domain_password> |

                      -P<domain_password_environment_variable>]

                     -i <input_file_name>

                     [-g (create globalrepository)]

                     [-y (enable objectversioning)]

                     [-b (skip workflow andsession logs)]

                     [-j (skip deployment grouphistory)]

                     [-q (skip MX data)]

                     [-f (skip taskstatistics)]

                     [-a (as new repository)]

                     [-e (exit if domain namein the binary file is different from current domain name)]

 

Usage: pmrep backup

                    -o <output_file_name>

                    [-d <description>]

                    [-f (overwrite existingoutput file)]

                    [-b (skip workflow andsession logs)]

                    [-j (skip deploy grouphistory)]

                    [-q (skip MX data)]

                    [-v (skip task statistics)]

 

Usage: pmrep registerplugin

                            -i<input_registration_file_name_or_path>

                            [-e (updateplug-in)]

                            [-l<NIS_login>

                             [-w <NIS_password> |

                              -W<NIS_password_environment_variable>]

                             [-k (CRC check onsecurity library)]]

                            [-N (is nativeplug-in)]

 

Usage: pmrep unregisterplugin

                              -v<vendor_id>

                              -l<plug-in_id>

                              [-s (is securitymodule)

                               [-g (removeuser-name-login mapping)]

                               {-w <new_password>|

                                -W<new_password_environment_variable>}]

 

Usage: pmrepinstallabapprogram

                                -s<folder_name>

                                -m<mapping_name>

                                [-v<version_number>]

                                [-l<log_filename>]

                                -u<user_name>

                                -x<password>

                                -c<connect_string>

                                -t <client>

                                [-y<language>]

                                {-f<input_file> |

                                 -p<program_mode (file, stream)>

                                 {-e (enableoverride)

                                  -o <override_name> }

                                  [-a(authority check)]

                                  [-n (usenamespace)] }

                                [-d<development_class_name>]

 

Usage: pmrepgenerateabapprogramtofile

                                       -s <folder_name>

                                       -m<mapping_name>

                                       [-v<version_number>]

                                       [-l<log_filename>]

                                       -u<user_name>

                                       -x<password>

                                       -c<connect_string>

                                       -t<client>

                                       [-y<language>]

                                       -p <program_mode (file,stream)>

                                       -f<output_file_location>

                                       {-e(enable override)

                                        -o<override_name> }

                                       [-a (authority check)]

                                       [-n (usenamespace)]

 

Usage: pmrepuninstallabapprogram

                                  -s<folder_name>

                                  -m<mapping_name>

                                  [-v <version_number>]

                                  [-l<log_filename>]

                                  -u<user_name>

                                  -x<password>

                                  -c<connect_string>

                                  -t <client>

                                  [-y<language>]

                                  -p<program_mode (file, stream)>

 

Usage: pmrep updatestatistics

Usage: pmrep updateemailaddr

                             -d<folder_name>

                             -s<session_name>

                             -u<success_email_address>

                             -f<failure_email_address>

 

Usage: pmrep updatetargprefix

                              -f<folder_name>

                              -s[<qualifying_path>.]<session_name>

                              [-t<target_name>]

                              -p<prefix_name>

            [-n (use target instance name; notusing -n gives old, deprecated behavior)]

Usage: pmrep updatesrcprefix

                             -f<folder_name>

                             -s[<qualifying_path>.]<session_name>

                             [-t<source_name>]

                             -p<prefix_name>

            [-n (use source instance name; notusing -n gives old, deprecated behavior)]

Usage: pmrep updateseqgenvals

                              -f<folder_name>

                              [-m<mapping_name>]

                              -t<sequence_generator_name>

                              [-s <start_value>]

                              [-e<end_value>]

                              [-i<increment_by>]

                              [-c<current_value>]

 

Usage: pmrep listobjects

                         -o <object_type>

                         [-t <object_subtype>]

                         [-f<folder_name>]

                         [-c<column_separator>]

                         [-r<end-of-record_indicator>]

                         [-l<end-of-listing_indicator>]

                         [-b (verbose)]

                          [-s <dbd_seperator>]

 

Usage: pmrep massupdate    -t <session_property_type(session_property, session_config_property,       transformation_instance_attribute,session_instance_runtime_option) >

                        -n <session_property_name>

                        -v<session_property_value>

                        [-w<transformation_type>]

                        {-i<persistent_input_file> |

                         -f<folder_name>}

                        [-o <condition_operator (equal,unequal, less, greater) >]

                        [-l<condition_value>]

                        [-g(update_session_instance_flag)]

                        [-m (test_mode)]

                        [-u <output_log_file_name>]

Usage: pmrep listtablesbysess

                              -f<folder_name>

                              -s[<qualifying_path>.]<session_name>

                              -t<object_type_listed> (source or target)

Usage: pmrep createconnection

                              -s<connection_type>

                              -n<connection_name>

                              -u<user_name>

                              [-p<password> |

                               -P<password_environment_variable>]

                              [-c<connect_string> (required for Oracle, Informix, DB2, ODBC,NetezzaRelational and NEOVIEW)]

               -l <code_page>

             [-r <rollback_segment>(valid for Oracle connection only)]

              -e <connection_environment_SQL>]

             [-f<transaction_environment_SQL>]

            [-z <packet_size> (valid forSybase ASE and MS SQL Server connection)]

            [-b <database_name> (validfor Sybase ASE, Teradata and MS SQL Server connection)]

            [-v <server_name> (valid forSybase ASE and MS SQL Server connection)]

             [-d <domain_name> (valid forMS SQL Server connection only)]

            [-t (enable trusted connection,valid for MS SQL Server connection only)]

            [-a <data_source_name> (validfor Teradata connection only)]

                              [-x (enableadvanced security, lets users give Read, Write and Execute permissions only forthemselves.)]

                              [-k<connection_attributes> (attributes have the formatname=value;name=value; and so on)]

 

Usage: pmrepswitchconnection  -o<old_connection_name>  -n<new_connection_name>

 

Usage: pmrepdeleteconnection  -n<connection_name>   [-f (forcedelete)]

        [ -s <connection type application,relational, ftp, loader or queue > ]

Usage: pmreplistconnections     [-t (output includesconnection subtype)]

Usage: pmrepgetconnectiondetails

                                  -n<connection name>

                                  -t<connection type>

 

Usage: pmrep deleteobject

                          -o <objecttype>

                          -f <foldername>

   -n <object name> (for source, usedbdname.sourcename and for all other objects use objectname)

                           [-s < dbd_seperator>]

Usage: pmrepshowconnectioninfo

Usage: pmrep updateconnection

                              -t<connection_subtype >

                              -d<connection_name>

                              [-u<new_user_name>]

                              [-p <new_password> |

                               -P<new_password_environment_variable>]

                              [-c<new_connection_string>]

                              [-a<attribute_name>

                               -v<new_attribute_value>]

                [ -s <connection typeapplication, relational, ftp, loader or queue > ]

                              [-l <codepage>]

Usage: pmrep createFolder

                          -n<folder_name>

                          [-d<folder_description>]

                          [-o<owner_name>]

                          [-a<owner_security_domain>]

                          [-s (shared_folder)]

                          [-p<permissions>]

                          [-f <active |frozendeploy | frozennodeploy>]

 

Usage: pmrep deleteFolder    -n <folder_name>

Usage: pmrep modifyFolder

                          -n<folder_name>

                          [-d<folder_description>]

                          [-o<owner_name>]

                          [-a <owner_security_domain>]

                          [-s (shared folder)]

                          [-p<permissions>]

                          [-r<new_folder_name>]

          [-f <folder_status> (active,frozendeploy, or frozennodeploy)]

                          [-u <os_profile>]

Usage: pmreplistuserconnections

Usage: pmrepkilluserconnection

                                {-i<connection_id> |

                                 -n<user_name> |

                                 -a (kill all)}

Usage: pmrep truncatelog

                         -t<logs_truncated> (all or up to end time in MM/DD/YYYY HH24:MI:SS formator as number of days before current date)

                         [-f<folder_name>]

                         [-w<workflow_name>]

 

Usage: pmrep AssignPermission

                              -o<object_type>

                              [-t<object_subtype>]

                              -n<object_name>

                              {-u<user_name> |

                               -g<group_name>}

                              [-s<security_domain>]

                              -p<permission>

Usage: pmrep ChangeOwner

                         -o <object_type>

                         [-t<object_subtype>]

                         -n <object_name>

                         -u<new_owner_name>

                         [-s<security_domain>]

Usage: pmrep executequery

                          -q <query_name>

                          [-t <query_type(shared or personal)>]

                          [-u<output_persistent_file_name>]

                          [-a (append)]

                          [-c<column_separator>]

                          [-r<end-of-record_separator>]

                          [-l<end-of-listing_indicator>]

                          [-b (verbose)]

                          [-n (do not includeparent path)]

                           [-s <dbd_seperator>]

 

Usage: pmrep createlabel

                         -a <label_name>

                         [-c <comments>]

 

Usage: pmrep deletelabel

                         -a <label_name>

                         [-f (force_delete)]

 

Usage: pmrep applylabel

                        -a <label_name>

                        {{-n<object_name>

                          -o<object_type>

                          [-t <object_subtype>]

                          [-v<version_number>]

                          [-f<folder_name>]} |

                         -i<persistent_input_file>}

                        [-d<dependency_object_types>]

                        [-p <dependency_direction(children, parents, or both)>]

                        [-s (include pk-fkdependency)]

                        [-g (acrossrepositories)]

                        [-m (move label)]

                        [-c <comments>]

                         [-e <dbd_seperator>]

 

Usage: pmrepcreatedeploymentgroup

                                   -p<deployment_group_name>

                                   [-t<deployment_group_type (static or dynamic)>]

                                   [-q <query_name>]

                                   [-u<query_type (shared or personal)>]

                                   [-c<comments>]

 

Usage: pmrepdeletedeploymentgroup

                                   -p<deployment_group_name>

                                   [-f(force_delete)]

 

Usage: pmrepcleardeploymentgroup

                                  -p<deployment_group_name>

                                  [-f(force_clear)]

 

Usage: pmrepaddtodeploymentgroup

                                  -p <deployment_group_name>

                                  {{-n<object_name>

                                    -o<object_type>

                                    [-t<object_subtype>]

                                    [-v<version_number>]

                                    [-f<folder_name>]} |

                                   -i<persistent_input_file>}

                                  [-d<dependency_types (all, non-reusable or none)>]

                                   [-s <dbd_seperator>]

 

Usage: pmrep findcheckout

                          [-o<object_type>]

                          [-f<folder_name>]

                          [-u (all_users)]

                          [-c<column_separator>]

                          [-r <end-of-record_separator>]

                          [-l<end-of-listing_indicator>]

                          [-b (verbose)]

                           [-s <dbd_seperator>]

 

Usage: pmrep checkin

                     -o <object_type>

                     [-t <object_subtype>]

                     -n <object_name>

                     -f <folder_name>

                     [-c <comments>]

                      [-s <dbd_seperator>]

 

Usage: pmrep undocheckout

                          -o<object_type>

                          [-t <object_subtype>]

                          -n<object_name>

                          -f<folder_name>

                           [-s <dbd_seperator>]

 

Usage: pmreplistobjectdependencies

                  {{-n <object_name>

                                      -o<object_type>

                                      [-t<object_subtype>]

                                      [-v<version_number>]

                                      [-f<folder_name>]} |

                                     -i <persistent_input_file>}

                                    [-d<dependency_object_types>]

                 [-p <dependency_direction(children, parents, or both)>]

                                    [-s(include pk-fk dependency)]

                                    [-g (acrossrepositories)]

                                    [-u<persistent_output_file_name>

                                     [-a(append)]]

                                    [-c<column_separator>]

                                    [-r<end-of-record_separator>]

                                    [-l<end-of-listing_indicator>]

                                    [-b(verbose)]

                                     [-e <dbd_seperator>]

Usage: pmrep deployfolder

                          -f <folder_name>

                          -c<control_file_name>

                          -r<target_repository_name>

                          [-n<target_repository_user_name>

                          [-s<target_repository_user_security_domain>]

                           [-x<target_repository_password> |

                            -X<target_repository_password_environment_variable>]

                           [-d<target_domain_name> |

                            {-h<target_portal_host_name>

            -o<target_portal_port_number>}]] (only if target is in a different domain)

                          [-l<log_file_name>]

Usage: pmreprollbackdeployment

                                -p<deployment_group_name>

                                -t <nth_latest_deploy_run>

Usage: pmrepdeploydeploymentgroup

                -p <deployment_group_name>

                -c <control_file_name>

                -r<target_repository_name>

                [-n<target_repository_user_name>

                 [-s<target_repository_user_security_domain>]

                 [-x<target_repository_password> |                                     -X<target_repository_password_environment_variable>]

               [-d <target_domain_name> |

              {-h <target_portal_host_name>

     -o <target_portal_port_number>}]](only if target is in a different domain)

                                   [-l<log_file_name>]

Usage: pmrep objectimport

                          -i<input_xml_file_name>

                          -c <control_file_name>

                          [-l<log_file_name>]

                          [-p (retainpersistent value)]

 

Usage: pmrep objectexport

                          {{-n<object_name>

                            -o <object_type>

                            [-t<object_subtype>]

                            [-v<version_number>]

                            [-f<folder_name>]} |

                           -i<persistent_input_file>}

                          [-m (export pk-fkdependency)]

                          [-s (export objectsreferred by shortcut)]

                          [-b (exportnon-reusable dependents)]

                          [-r (export reusabledependents)]

                          -u <xml_output_file_name>

                          [-l<log_file_name>]

                           [-e <dbd_seperator>]

 

Usage: pmrep validate

                      {{-n <object_name>

                        -o <object_type(mapplet, mapping, session, worklet, workflow)>

                        [-v<version_number>]

                        [-f<folder_name>]} |

                       -i<persistent_input_file>}

                      [-s (save upon valid)

                       [-k (check in uponvalid)

                        [-m <check_in_comments>]]]

                      [-p<output_option_types (valid, saved, skipped, save_failed, invalid_before,invalid_after, or all)>]

                      [-u<persistent_output_file_name>

                       [-a (append)]]

                      [-c <column separator>]

                      [-r<end-of-record_separator>]

                      [-l<end-of-listing_indicator>]

                      [-b (verbose)]

 

Usage: pmrep version

Usage: pmrep purgeversion

                          {-d <all | time_date | num_day> |

                            {-n<last_n_versions_to_keep> |

                             -t <time_date |num_day>}}

                          [-f<folder_name>]

                          [-q<query_name>]

                          [-o <output_file_name>]

                          [-p (preview purgedobjects only)]

                          [-b (verbose)]

                          [-c (check deploymentgroup reference)]

                           [-s <dbd_seperator>]

 

Usage: pmrep register

                      -r<local_respoitory_name>

                      -n<local_repository_user_name>

                      [-s<local_repository_user_security_domain>]

                      [-x<local_repository_password> |

                       -X<local_repository_password_environment_variable>]

                      [-d<local_repository_domain_name> |

                       {-h<local_repository_portal_host_name>

                        -o<local_repository_portal_port_number>}] (only if local repository is in adifferent domain)

 

Usage: pmrep unregister

                        -r<local_repository_name>

                        -n<local_repository_user_name>

                        [-s<local_repository_user_security_domain>]

                        [-x<local_repository_password> |

                         -X<local_repository_password_environment_variable>]

                        [-d<local_repository_domain_name> |

                         {-h<local_repository_portal_host_name>

                          -o<local_repository_portal_port_number>}] (only if local repository is in adifferent domain)

 

Usage: pmrep notify

                    -m <message>

Usage: pmrep help

                  help [command].

Usage: pmrep -help

                   help [command].

Usage: pmrep cleanup

 


  • 0
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
### 回答1: Informatica并不是一个免费的软件。Informatica是一家专门从事数据集成、数据质量和数据管理解决方案的软件公司。该公司提供了一系列的软件产品和工具,用于帮助企业有效地管理、整合和优化其数据资源。 Informatica的产品和服务被广泛应用于全球各个行业,包括金融、保险、零售、能源、制造等。这些产品和服务可以帮助企业实现数据集成、数据转换、数据加载、数据质量清洗、数据质量管理、数据分析等功能。通过使用Informatica的解决方案,企业可以更好地管理和利用其数据资源,提高决策的准确性和效率,增强竞争力和业务成果。 然而,Informatica的产品和服务都是收费的,企业需要购买相应的许可证或订阅服务来使用。价格因产品和服务的类型、规模和部署方式而有所不同。Informatica也提供了不同的许可模式和定价方案,以满足不同企业的需求和预算。企业可以根据自身的需求选择合适的产品和服务,并与Informatica的销售团队进行商议以获取相关的详细信息和报价。 总结而言,尽管Informatica提供了强大的数据管理解决方案,但它并不是免费的软件。企业需要购买相关的许可证或订阅服务来使用Informatica的产品和服务。 ### 回答2: Informatica是一家知名的数据集成软件公司,提供各种数据管理和数据集成解决方案。然而,目前的情况是,Informatica并不是免费的软件。 Informatica公司的产品涵盖了数据集成、数据质量、数据湖和数据治理等多个领域,旨在帮助企业更好地管理和利用自身的数据资产。这些产品通常都是经过精心设计和开发的,具有高度专业性和可靠性,因此需要付费购买并获得许可证才能使用。 不过,对于个人用户或小型组织,Informatica也提供一些试用或免费的产品和服务。比如,Informatica提供了一款名为PowerCenter Express的免费版软件,可以用于个人或小型项目的数据集成和转换。此外,Informatica还提供了一些免费的在线学习资源,供用户学习和使用其产品。 总的来说,Informatica并非完全免费,大型企业购买该公司的产品和解决方案时需要支付相应的费用。不过,对于个人用户或小型组织来说,可以通过一些限制版或免费版的软件和服务来满足其基本需求。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值