注册 留言板
当前位置:首页 > 企业级应用 > Informatica > 正文

FAQ: How to update the "Source file Directory" or "Output file directory" properties of multiple PowerCenter sessions that uses FlatFile source or target, together?

来源:INFOCOOL   发布时间: 2017-06-17   作者:网友   浏览次数:
摘要: FAQ: How to update the "Source file Directory" or "Output file directory" properties of multiple PowerCenter sessions ...
FAQ: How to update the "Source file Directory" or "Output file directory" properties of multiple PowerCenter sessions that uses FlatFile source or target, together?
Answer
​​The properties  Source file directory or Output File Directory for the FlatFile source and FlatFile target, for multiple sessions could be updated together using the pmrep MassUpdate command. 

With this command, these properties of multiple sessions could be edited. These sessions that need to be updated could be provided in a persistent input file (this file could be generated using the  pmrep ExecuteQuery command to run a query and generate this file.), or could be from the same folder.

The following is an example of editing the Source File Directory property to $PMSourceFileDir of a set of sessions that are a part of the same folder:

pmrep massupdate -t transformation_instance_attrib ute -n "Source file directory" -v $PMSourceFileDir -w "source definition" -f "foldername" -o equal -l /home/user/sourcefile -g -u hr.log
​​

More Information
​The following is the format of the pmrep massupdate command:

pmrepmassupdate
-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>] 

Applies To
Product(s): PowerCenter
Product Version(s): PowerCenter

Last Modified Date:6/16/2017 2:50 AMID:ID:501147
People who viewed this also viewed


我来说两句
评论内容:
验  证  码:
 
(网友评论仅供其表达个人看法,并不表明本站同意其观点或证实其描述。)
评论列表
已有 0 条评论(查看更多评论)
精彩专题
  • 本月排行
  • 总排行
友情链接:
QQ交流群:①群 155252576 INFOCOOL官方交流群 ②群 469193068 WEB前端技术交流群 ③群 531831996 数据库交流群 ④群 243504572 编程技术交流群
设为首页 - 加入收藏 Copyright @2016 Infocool 版权所有 粤ICP备16000626号