informatica 下载地址9.1的下载地址
点击联系发帖人
时间：2015-07-25 03:35
问题补充&&
本页链接：
9、填入目录名
2;* 在**库用户BI_TARGET中创建TARGET表 */.16，单击完成
6，双击joiner transformation表头.4, 5、在informatica powercenter designer设计器中单击菜单tools->、目标**库用户 /、接着把目标表target拖入右侧.8.7，
6,再单击菜单targets->.6把两个表中的字段拖入joiner transformation中、输入用户名和密码、输入完映射名后按ok键
5,完成工作流部分设置
片在出的对话框中选择conditi选项,导入**源
3、菜单tools->，映射规则定义完成 六、同样，单击下一步.12，单击下一步
6.2，按re-connect按钮,然后单击下一步.2连接进入informatica powercenter workflow manager
6.10、菜单workflows->、用同样方式再设定一个目标**库
6、创建**源，选择**源
6、输入**库连接源**、在repositories中拖动源**表dept和emp到右侧的mapping designer视图;source analyzer
3.7、 定义**源 3.1;workflows designer
6,在下方输入要导入的源**库表
3;create
2.5;* 创建源**库用户BI_SOURCE */，单击 按钮, ENAME VARCHAR2(10).1; profile DEFAULT、 新建文件夹 2，然后点击菜单->、 定义目标** 4.7、 启动工作流 7.6，
3.9，选择start workflow
7、 定义工作流 6，按ok按钮
6, MGR **MBER(4)、选择oracle类型，出odbc**源管理器.2.
3.1.15、最后:
5; create table TARGET ( EMPNO **MBER(4) not **ll.5，然后在右侧的connections下单击 按钮、打开informatica PowerCenter Designer设计器并登录
4，添加一个deptno1=deptno的联系，单击“添加”按钮
3，单击左侧sources选项组下面的源**表:
6, JOB VARCHAR2(9).1; create user BI_SOURCE identified by password profile DEFAULT:
5、按右键, DEPTNO **MBER(2); grant dba to BI_SOURCE; 二、点击菜单repository->.13、选中scott文件夹、在workflow designer视图中双击s_dept_emp_map.6，输入源**库配置参数;import from database，然后按确定按钮.5.......余下全文>>
huanglenzhi &
•回答
•回答
•回答
•回答
•回答
猜你感兴趣
服务声明： 信息来源于互联网，不保证内容的可靠性、真实性及准确性，仅供参考，版权归原作者所有！Copyright &
Powered byINFORMATICA POWERCENTER 9.1 英文教程
INFORMATICA POWERCENTER 9.1 英文教程
Informatica Powercenter 9.1 PDF 教程（英文版），包括 IDP Developer Guide: This document talks about the application programming interfaces (APIs) that enable you to embed data integration capabilities in an enterprise application Advanced Workflow Guide: Advanced workflow guide discusses about topics like Pipeline Partitioning, Pushdown Optimization, Real-Time Processing, Grid Processing, External Loading etc. Data Profiling Guide: Data profiling guide helps you to understand, analyze the content, quality and structure of data. Designer Guide: You can learn how to import or create Sources, Targets, create Transformations, Mappings, Mapplets and so on. Getting Started Guide: This document will help you on how to use the Informatica PowerCenter tool. Installation and Configuration Guide: Learn how to install Informatica on multiple nodes and configuring it. Mapping Analysis for Excel: PowerCenter mappings in Microsoft Office Excel, and to export PowerCenter mappings to Microsoft Office Excel Mapping Architect Visio Guide: Mapping Architect for Visio helps you to create mapping templates using Microsoft Office Visio. Performance Tuning Guide: Helps you to understand how to optimize source, target, transformation, mapping, sessions etc. Repository Guide: Helps in you understanding the repository architecture, metadata and repository object locks. Transformation Guide: Learn about different transformation in Informatica version 9. Web Services Provider Guide: Web services describe a collection of operations that are network accessible through standardized XML messaging.
（本资料免费下载）
本资料由网友发布，仅代表网友个人经验或观点，不代表本网站立场和观点。如果本资料侵犯了您的知识产权，请与我们取得联系，我们会及时处理。
&&&主编推荐
&&&&&&&&&&&&&&&
希赛网 版权所有 & &&&&湘教QS2-164&&增值电信业务经营许可证湘B2-Informatica 9.1常用查询 - xuzhengzhu - 博客园
把握现在,领导未来
posts - 527, comments - 16, trackbacks - 18, articles - 0
a.mapping_name,
a.mapping_id,
a.subject_id,
a.is_valid,
b.pv_precision,
c.pv_value,
b.pv_default,
opb_mapping a,
opb_map_parmvar b,
OPb_map_persisval c
where a.mapping_id=b.mapping_id
and c.mapping_id=a.mapping_id
查询Mapping参数变量
select distinct SUBJ_NAME as folder_name,
x.mapping_name,
decode(widget_type, 1, instance_name) as src
from opb_widget_inst t, opb_mapping x, opb_subject y
WHERE widget_type in (1, 2)
and t.mapping_id = x.mapping_id
and x.subject_id = y.subj_id
and decode(widget_type, 1, instance_name) in('DW_F_SBJMXX','DW_F_ZSXX','DW_F_JRKXX')
ORDER BY FOLDER_NAME,mapping_name
查询mapping与数据源表 语句
from opb_workflow a, opb_scheduler b,opb_server_info c
where a.scheduler_id = b.scheduler_id
and a.server_id = c.server_id
查询服务器、工作流、计划等信息
SELECT T.SUBJECT_AREA
T.WORKFLOW_NAME
工作流名称,
T.TASK_TYPE
T.TASK_TYPE_NAME
T.INSTANCE_NAME
实际运行组件名,
T.TASK_NAME
初始组件名,
T.START_TIME
T.END_TIME
T.RUN_STATUS_CODE 执行状态,
T.RUN_ERR_CODE
T.RUN_ERR_MSG
FROM REP_TASK_INST_RUN T
t.TASK_TYPE_NAME='Worklet'--取值为Workflow重的组件名称：'Session','Command','Start','Control','Timer','Worklet ,
AND t.START_TIME&= TRUNC(SYSDATE-1)
查询任务运行情况
SELECT T1.SUBJECT_AREA
T1.WORKFLOW_NAME
工作流名称,
T1.SESSION_INSTANCE_NAME
T1.MAPPING_NAME
T1.SUCCESSFUL_SOURCE_ROWS 源成功num,
T1.FAILED_SOURCE_ROWS
源失败num,
T1.SUCCESSFUL_ROWS
目标成功num,
T1.FAILED_ROWS
目标失败num,
t1.ACTUAL_START
t1.FIRST_ERROR_CODE
t1.FIRST_ERROR_MSG
FROM REP_SESS_LOG T1
WHERE t1.ACTUAL_START&TRUNC(SYSDATE)
查询SESSION运行情况
SELECT START_TIME
SUBJECT_AREA
WORKFLOW_NAME
RUN_STAT_CODE
RUN_ERR_CODE
RUN_ERR_MSG
MAPPING_NAME
SUSSESSFUL_SOURC_ROWS SSR,
FAILED_SOURCE_ROWS
SUCCCESSFUL_ROWS
FAILED_ROWS
FROM (SELECT T1.START_TIME
START_TIME,
T1.END_TIME
T.SUBJECT_AREA
SUBJECT_AREA,
T.WORKFLOW_NAME
WORKFLOW_NAME,
T2.INSTANCE_NAME
T1.INSTANCE_NAME
SESS_NAME,
T1.RUN_STATUS_CODE
RUN_STAT_CODE,
T1.RUN_ERR_CODE
RUN_ERR_CODE,
T1.RUN_ERR_MSG
RUN_ERR_MSG,
T.MAPPING_NAME
MAPPING_NAME,
T.SUCCESSFUL_SOURCE_ROWS SUSSESSFUL_SOURC_ROWS,
T.FAILED_SOURCE_ROWS
FAILED_SOURCE_ROWS,
T.SUCCESSFUL_ROWS
SUCCCESSFUL_ROWS,
T.FAILED_ROWS
FAILED_ROWS
FROM REP_SESS_LOG T
INNER JOIN REP_TASK_INST_RUN T1
ON T.SUBJECT_ID = T1.SUBJECT_ID
AND T.WORKFLOW_ID = T1.WORKFLOW_ID
AND T.WORKFLOW_RUN_ID = T1.WORKFLOW_RUN_ID
AND T.WORKLET_RUN_ID = T1.WORKLET_RUN_ID
AND T.SESSION_ID = T1.TASK_ID
AND T1.TASK_TYPE_NAME = 'Session'
LEFT JOIN REP_TASK_INST_RUN T2
ON T1.SUBJECT_ID = T2.SUBJECT_ID
AND T1.WORKFLOW_ID = T2.WORKFLOW_ID
AND T1.WORKFLOW_RUN_ID = T2.WORKFLOW_RUN_ID
AND T1.WORKLET_RUN_ID = T2.CHILD_RUN_ID
AND T2.TASK_TYPE_NAME = 'Worklet'
--AND t.ACTUAL_START&TRUNC(SYSDATE)
WHERE SESS_NAME = 's_m_F_Posbk_Sale1_6'
ORDER BY START_TIME;
查询工作流运行情况cm9.1.0 fl studio 9.1.0 flashtool0.9.1.0 powerce..
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
Informatica 9.1.0 upgrade for PowerCenter 8.5.x and 8.6.x
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='/DocinViewer-4.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口}
本页链接：
9、填入目录名
2;* 在**库用户BI_TARGET中创建TARGET表 */.16，单击完成
6，双击joiner transformation表头.4, 5、在informatica powercenter designer设计器中单击菜单tools->、目标**库用户 /、接着把目标表target拖入右侧.8.7，
6,再单击菜单targets->.6把两个表中的字段拖入joiner transformation中、输入用户名和密码、输入完映射名后按ok键
5,完成工作流部分设置
片在出的对话框中选择conditi选项,导入**源
3、菜单tools->，映射规则定义完成 六、同样，单击下一步.12，单击下一步
6.2，按re-connect按钮,然后单击下一步.2连接进入informatica powercenter workflow manager
6.10、菜单workflows->、用同样方式再设定一个目标**库
6、创建**源，选择**源
6、输入**库连接源**、在repositories中拖动源**表dept和emp到右侧的mapping designer视图;source analyzer
3.7、 定义**源 3.1;workflows designer
6,在下方输入要导入的源**库表
3;create
2.5;* 创建源**库用户BI_SOURCE */，单击 按钮, ENAME VARCHAR2(10).1; profile DEFAULT、 新建文件夹 2，然后点击菜单->、 定义目标** 4.7、 启动工作流 7.6，
3.9，选择start workflow
7、 定义工作流 6，按ok按钮
6, MGR **MBER(4)、选择oracle类型，出odbc**源管理器.2.
3.1.15、最后:
5; create table TARGET ( EMPNO **MBER(4) not **ll.5，然后在右侧的connections下单击 按钮、打开informatica PowerCenter Designer设计器并登录
4，添加一个deptno1=deptno的联系，单击“添加”按钮
3，单击左侧sources选项组下面的源**表:
6, JOB VARCHAR2(9).1; create user BI_SOURCE identified by password profile DEFAULT:
5、按右键, DEPTNO **MBER(2); grant dba to BI_SOURCE; 二、点击菜单repository->.13、选中scott文件夹、在workflow designer视图中双击s_dept_emp_map.6，输入源**库配置参数;import from database，然后按确定按钮.5.......余下全文>>
huanglenzhi &
•回答
•回答
•回答
•回答
•回答
猜你感兴趣
服务声明： 信息来源于互联网，不保证内容的可靠性、真实性及准确性，仅供参考，版权归原作者所有！Copyright &
Powered byINFORMATICA POWERCENTER 9.1 英文教程
INFORMATICA POWERCENTER 9.1 英文教程
Informatica Powercenter 9.1 PDF 教程（英文版），包括 IDP Developer Guide: This document talks about the application programming interfaces (APIs) that enable you to embed data integration capabilities in an enterprise application Advanced Workflow Guide: Advanced workflow guide discusses about topics like Pipeline Partitioning, Pushdown Optimization, Real-Time Processing, Grid Processing, External Loading etc. Data Profiling Guide: Data profiling guide helps you to understand, analyze the content, quality and structure of data. Designer Guide: You can learn how to import or create Sources, Targets, create Transformations, Mappings, Mapplets and so on. Getting Started Guide: This document will help you on how to use the Informatica PowerCenter tool. Installation and Configuration Guide: Learn how to install Informatica on multiple nodes and configuring it. Mapping Analysis for Excel: PowerCenter mappings in Microsoft Office Excel, and to export PowerCenter mappings to Microsoft Office Excel Mapping Architect Visio Guide: Mapping Architect for Visio helps you to create mapping templates using Microsoft Office Visio. Performance Tuning Guide: Helps you to understand how to optimize source, target, transformation, mapping, sessions etc. Repository Guide: Helps in you understanding the repository architecture, metadata and repository object locks. Transformation Guide: Learn about different transformation in Informatica version 9. Web Services Provider Guide: Web services describe a collection of operations that are network accessible through standardized XML messaging.
（本资料免费下载）
本资料由网友发布，仅代表网友个人经验或观点，不代表本网站立场和观点。如果本资料侵犯了您的知识产权，请与我们取得联系，我们会及时处理。
&&&主编推荐
&&&&&&&&&&&&&&&
希赛网 版权所有 & &&&&湘教QS2-164&&增值电信业务经营许可证湘B2-Informatica 9.1常用查询 - xuzhengzhu - 博客园
把握现在,领导未来
posts - 527, comments - 16, trackbacks - 18, articles - 0
a.mapping_name,
a.mapping_id,
a.subject_id,
a.is_valid,
b.pv_precision,
c.pv_value,
b.pv_default,
opb_mapping a,
opb_map_parmvar b,
OPb_map_persisval c
where a.mapping_id=b.mapping_id
and c.mapping_id=a.mapping_id
查询Mapping参数变量
select distinct SUBJ_NAME as folder_name,
x.mapping_name,
decode(widget_type, 1, instance_name) as src
from opb_widget_inst t, opb_mapping x, opb_subject y
WHERE widget_type in (1, 2)
and t.mapping_id = x.mapping_id
and x.subject_id = y.subj_id
and decode(widget_type, 1, instance_name) in('DW_F_SBJMXX','DW_F_ZSXX','DW_F_JRKXX')
ORDER BY FOLDER_NAME,mapping_name
查询mapping与数据源表 语句
from opb_workflow a, opb_scheduler b,opb_server_info c
where a.scheduler_id = b.scheduler_id
and a.server_id = c.server_id
查询服务器、工作流、计划等信息
SELECT T.SUBJECT_AREA
T.WORKFLOW_NAME
工作流名称,
T.TASK_TYPE
T.TASK_TYPE_NAME
T.INSTANCE_NAME
实际运行组件名,
T.TASK_NAME
初始组件名,
T.START_TIME
T.END_TIME
T.RUN_STATUS_CODE 执行状态,
T.RUN_ERR_CODE
T.RUN_ERR_MSG
FROM REP_TASK_INST_RUN T
t.TASK_TYPE_NAME='Worklet'--取值为Workflow重的组件名称：'Session','Command','Start','Control','Timer','Worklet ,
AND t.START_TIME&= TRUNC(SYSDATE-1)
查询任务运行情况
SELECT T1.SUBJECT_AREA
T1.WORKFLOW_NAME
工作流名称,
T1.SESSION_INSTANCE_NAME
T1.MAPPING_NAME
T1.SUCCESSFUL_SOURCE_ROWS 源成功num,
T1.FAILED_SOURCE_ROWS
源失败num,
T1.SUCCESSFUL_ROWS
目标成功num,
T1.FAILED_ROWS
目标失败num,
t1.ACTUAL_START
t1.FIRST_ERROR_CODE
t1.FIRST_ERROR_MSG
FROM REP_SESS_LOG T1
WHERE t1.ACTUAL_START&TRUNC(SYSDATE)
查询SESSION运行情况
SELECT START_TIME
SUBJECT_AREA
WORKFLOW_NAME
RUN_STAT_CODE
RUN_ERR_CODE
RUN_ERR_MSG
MAPPING_NAME
SUSSESSFUL_SOURC_ROWS SSR,
FAILED_SOURCE_ROWS
SUCCCESSFUL_ROWS
FAILED_ROWS
FROM (SELECT T1.START_TIME
START_TIME,
T1.END_TIME
T.SUBJECT_AREA
SUBJECT_AREA,
T.WORKFLOW_NAME
WORKFLOW_NAME,
T2.INSTANCE_NAME
T1.INSTANCE_NAME
SESS_NAME,
T1.RUN_STATUS_CODE
RUN_STAT_CODE,
T1.RUN_ERR_CODE
RUN_ERR_CODE,
T1.RUN_ERR_MSG
RUN_ERR_MSG,
T.MAPPING_NAME
MAPPING_NAME,
T.SUCCESSFUL_SOURCE_ROWS SUSSESSFUL_SOURC_ROWS,
T.FAILED_SOURCE_ROWS
FAILED_SOURCE_ROWS,
T.SUCCESSFUL_ROWS
SUCCCESSFUL_ROWS,
T.FAILED_ROWS
FAILED_ROWS
FROM REP_SESS_LOG T
INNER JOIN REP_TASK_INST_RUN T1
ON T.SUBJECT_ID = T1.SUBJECT_ID
AND T.WORKFLOW_ID = T1.WORKFLOW_ID
AND T.WORKFLOW_RUN_ID = T1.WORKFLOW_RUN_ID
AND T.WORKLET_RUN_ID = T1.WORKLET_RUN_ID
AND T.SESSION_ID = T1.TASK_ID
AND T1.TASK_TYPE_NAME = 'Session'
LEFT JOIN REP_TASK_INST_RUN T2
ON T1.SUBJECT_ID = T2.SUBJECT_ID
AND T1.WORKFLOW_ID = T2.WORKFLOW_ID
AND T1.WORKFLOW_RUN_ID = T2.WORKFLOW_RUN_ID
AND T1.WORKLET_RUN_ID = T2.CHILD_RUN_ID
AND T2.TASK_TYPE_NAME = 'Worklet'
--AND t.ACTUAL_START&TRUNC(SYSDATE)
WHERE SESS_NAME = 's_m_F_Posbk_Sale1_6'
ORDER BY START_TIME;
查询工作流运行情况cm9.1.0 fl studio 9.1.0 flashtool0.9.1.0 powerce..
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
Informatica 9.1.0 upgrade for PowerCenter 8.5.x and 8.6.x
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='/DocinViewer-4.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口}
我要回帖
更多关于 informatica 下载地址 的文章
更多推荐
- ·遗体怎么从外地运回家人在北京死了能出北京吗
- ·新疆乌鲁木齐拖车到喀什多少钱能进加油站吗
- ·参加长沙碧桂园凤凰酒店电话1楼拉齐奥厅会议被同城本地微生活骗了？
- ·新疆乌鲁木齐最好的职高什么班
- ·一直犹豫假期不知道去哪里玩比较好玩玩，有推荐的地点吗?
- ·cool edit 的变调器和无暇音频变速变调器器怎么协调起来用
- ·led演播室是否通用所有室内全彩屏彩屏
- ·看老婆被别人操 小说说的种子是用什么看的？
- ·请问这文教资料怎么样样
- ·求《类似于花与蛇的电影》系列的资源
- ·爱草媒草柳社社区2015邀请码码是多少？
- ·苹果万能钥匙激活码电脑激活码W80434ZRAGW 谁能帮我查到是哪年哪时激活的。感谢
- ·求露娜3D和太空女妖2的工口game，老是下载的不能玩，379949396
- ·有资源吗，优衣库视频资源
- ·花千骨15正片29集正片
- ·2013cad激活码申请号
- ·求人防工程07fd02人防电气图集集07FD02，急需，望大师们能发给我，谢谢了。
- ·冰与火的青春全集下载地址
- ·求探索者的目标动漫系列动漫
- ·coreldraw x7激活码6计算激活码
- ·informatica 下载地址9.1的下载地址
- ·依法执教演讲稿治企演讲稿，，大神们帮帮忙
- ·六房间美女视频哪呢彩云牡丹视频怎么能看到
- ·谁有WIN7 32位系统下支持win7 64 cad20088的？（带注册机的）
- ·水谷幸也迅雷资源的资源，谁可以给我
- ·您好,请问你还有老友记第六季的视频吗？能不能发我一下 谢谢您！
- ·同志亦凡人网站 thank you!!
- ·跪求哔哩哔哩动画邀请码会员邀请码，我考了好几次就差一点，求大神帮忙
- ·mc阳子父亲mc天佑花千骨背景音乐乐
- ·谁分享一求个qq旋风会员员
- ·我购买了一个满3月的富贵uid!登录进去为什么进一些板说还要用第一会所s001邀请码码注册,是怎么回事
- ·求kyle ross 百度网盘资源
- ·轻狂ce修改器使用方法视频视频
- ·iPhone6买的是七月二十四号iphone6序列号怎么看查询是到明年七月二十九号，这正常吗？
- ·来回苹果5s刷机教程型号和序列号都没变的黑机5s是正品吗
