Source Qualifier Transformation
来源:互联网 发布:矩阵分析 教材 编辑:程序博客网 时间:2024/05/22 14:22
当Source Qualifier Transformation使用sql query override的话,所有的ports按顺序连接到downstream时不能断节,可以从最后依次不连接,但是从前面或者中间不连接是不可以的,否则报错。
Source Qualifier Transformation支持Oracle分析函数 比如:
select a.*, max(org_wid) over() as max_wid from WC_POSTN_COACH_A_TEST1 a
Output is Deterministic
Transformation Indicates that the transformation always generates the same set of data from the same input data.The Integration Service can resume a session from the last checkpoint when the output is repeatable and deterministic.
When you enable this option with the Output is Repeatable option for a relational source qualifier, the Integration Service does not save the SQL results to shared storage.
Output is Repeatable
Transformation Indicates whether the transformation generates rows in the same order between session runs. The Integration Service can resume a session from the last checkpoint when the output is repeatable and deterministic.
When you enable this option with the Output is Deterministic option for a relational source qualifier, the Integration Service does not save the SQL results to shared storage.
Warning: If you configure a transformation as repeatable and deterministic, it is your responsibility to ensure that
the data is repeatable. If you try to recover a session with transformations that do not generate repeatable and
deterministic data, the recovery process can result in corrupted data.
Infa Workflow的Source instancs的Out Field和SQ Transformation的Input Field只要Datatype对应没问题就可以。
- Source Qualifier Transformation
- Informatioa - Source Qualifier Customer Query
- 第一节 常用组件 之 Source Qualifier 概述
- 第九节 常用组件 之 Source Qualifier Distinct
- @Qualifier
- Modern source-to-source transformation with Clang and libTooling
- 第二节 常用组件 之 Source Qualifier 默认查询
- 第三节 常用组件 之 Source Qualifier 连接源数据
- 第四节 常用组件 之 Source Qualifier 添加 SQL 语句
- 第六节 常用组件 之 Source Qualifier 外部联接
- 第七节 常用组件 之 Source Qualifier 输入过滤器
- 第八节 常用组件 之 Source Qualifier 使用排序端口
- 第十一节 常用组件 之 Source Qualifier 创建SQ转换
- Transformation
- 第五节 常用组件 之 Source Qualifier 输入用户定义的联接
- 第十节 常用组件 之 Source Qualifier 会话前和会话后 SQL
- Spring @Qualifier
- @Qualifier example
- 关于linux上mysql.sock文件的个人理解
- HttpClient(六)
- 名词解释2
- GridView每行显示不同列数效果模拟
- 织梦调用图集幻灯片
- Source Qualifier Transformation
- GlusterFs分布式复本卷 服务器替换实践
- 三种方式修改数据库的引擎
- LSF系统介绍
- 黑马程序员-----------------collection 集合类集框架概述及简要分析
- openfire-spark 二次开发-(三)源码系统总览-1
- Java编程思想/Android架构
- hadoop第九讲
- 织梦搜索标签调用