informatica
文章平均质量分 57
indifferent_to
he
展开
-
informatica 的shell command集合
命令和相关参数Usage: pmrep run-f [-o ][-e (echo commands)][-s (stop at first error)][-u (UTF-8 encoded script file and output file)]Usage: pmrep connect(会产生一个连接配置文件,多人使用时,需要转载 2015-01-30 17:21:28 · 3011 阅读 · 0 评论 -
Informatica Dynamic Lookup Cache
ALookUp cache does not change its data once built. But what if the underlyingtable upon which lookup was done changes the data after the lookup cache iscreated? Is there a way so that the cache always翻译 2015-03-11 16:53:48 · 1654 阅读 · 0 评论 -
Transformation——Lookup 【待续】
properties->connection information在mapping里配置lookup的时候,不可以附上user defined connection parameter1只可以用informatica自带的variable:$Target、$Source2Hard code ,Relational:/Application:user defined原创 2015-02-05 18:44:03 · 429 阅读 · 0 评论 -
【方法】输出workflow相关的运行指标到target中
以输出workflow开始运行的时间为例:首先在workflow中创建workflow级变量$$test(datetype:date/time )其次在双击Start后面的link,将starttime赋给刚才定义的wk变量$$test回到Designer,给相应的mapping中添加变量mapping级变量$$test(datetype:date/time )原创 2015-02-05 13:15:34 · 788 阅读 · 0 评论 -
批量导出informatica object 的shell script
#!/bin/bash # -----------------------------------------------------------------------# Script Name: inf_impobj.sh# Purpose: To batch export mappings or workflows to xml files # Created by: indiff原创 2015-02-05 14:14:28 · 1277 阅读 · 0 评论 -
批量导入xml到informatica repository中的shell script
主要利用pmrep的objectimport命令,该命令执行时需要配置control file(xml文件,配置导入的一些参数和设置)script:#!/bin/bash# -----------------------------------------------------------------------# Script Name: inf_impobj.sh# Purpo原创 2015-02-05 14:24:39 · 2293 阅读 · 0 评论 -
Mapping Designer里实用autolink提高效率
在mapping中,可能遇到source和target的column位置不一致,当column的数量比较多的时候,手动拖得效率就比较低,学会实用autolink,可以大大提高效率。首先调整好target的column顺序(你想要输出的序列),之前的转化不必调整column的顺序,最后link到target的时候,右击空白处,autolink by name,这是鼠标变成十字,按住左原创 2015-02-05 11:44:49 · 498 阅读 · 0 评论 -
Worklet Excute Lock
在run workflow 的过程中,worklet failed,re-run后success。 workflow的log里的ERROR Message是这样的:问题的原因:改worklet被在另一个workflow中被同时执行,由于该worklet中的两个session不是resuable,产生了excute lock。解决方法(建议):将worklet原创 2015-02-03 11:44:49 · 619 阅读 · 0 评论 -
informatica exported objects(xml structure)
As you know, we can export objects(souce,target,mapping....) from informatica repository. If you are familiar with their the XML structure, you can easily use DOM to create or edit them.Note: if inf原创 2015-01-30 10:49:02 · 1335 阅读 · 0 评论 -
Dynamic Lookup 概念
What isDynamic Lookup? When lookup used DynamicCache then it's called as a Dynamic Lookup. What isDynamic Cache? Dynamic Cache may getupdated during mapping run. Means new records would be转载 2015-03-11 16:52:33 · 1364 阅读 · 0 评论