thy822的专栏

infotmatica 优化

通过编写存储过程填充日期维表这种方法可以生成时间段任意长的日期维表数据。首先创建日期维表：create table DIM_DATE_T(  F_DATEDATE,  F_YEAR  VARCHAR2(10),  F_MONTH VARCHAR2(10),  F_DAY   VARCHA

有人能解释一下下面的SQL么?  查过文献没找到答案.SELECT LEVELFROM dualCONNECT BY LEVEL 结果是:1                                   2                                   3                                   4 

INFORMATICA INTERVIEW QUESTIONS ON UPDATE STRATEGY TRANSFORMATION1. What is an update strategy transformation?Update strategy transformation is used to flag source rows for insert, updat

Incremental Aggregation is the process of capturing the changes in the source and calculating the aggregations in a session. This process makes the integration service to update the target increment

Mapping 调优1) 尽量在source qualifier里过滤数据2) Join的时候，用数据量较少的表作为Master Table, 尽量用整型字段作为key来join3) 用aggregator, joiner的时候，如果能确认输入的数据已排过序, 可以打开sorted input. (Data must be sorted in the order of th

INFORMATICA INTERVIEW QUESTIONS ON ROUTER TRANSFORMATION1. What is a router transformation?A router is used to filter the rows in a mapping. Unlike filter transformation, you can specify one o

增量聚集（Incremental Aggregation）PowerCenter Server 运行你增量的修改目标（target），而不是强迫process整个源和重新计算。用增量聚集的条件：Mapping 包含聚集函数；源（source）只做增量的改变；增量的改变能被捕捉。如果用时间戳等。不用增量聚集的情况：不能捕捉到新的源数据源数据的改变会导致很多的目

Thanks for your response. Here is the sample data information: A id1 $200 A id1 $300 A id2 $150 B id3 $100 B id4 $20 I want the following in the output: Name distinct-Count Totalamt 

说明：1 saprfc.ini文件一点要用wordpad保存，最好是删掉所有注释2 saprfc.ini的系统变量路径：RFC_INI=C:\Informatica\9.5.0\clients\PowerCenterClient\client\bin\saprfc.ini（最好包含完整路径） SAP uses the communications protocol, Remote

http://www.docin.com/p-226446813.htmlhttp://wenku.baidu.com/view/49c10b83d4d8d15abe234ec2.html

Here is my thinking after looking at both products... First of all let me tell you what I like about informatica.... - Inbuilt tool to export mappings to Excel and Visio.... helpful to document

Informatica 8.6 download procedure steps (For windows Xp 32/64)1)open this link  http://edelivery.oracle.com/EPD/GetUserInfo/get_form?caller=WelcomePage 2) open this link and fil

Oracle的官网上有它OEM版的Informatica PowerCenter 8.6，支持以SQL Server数据库作为service master db:http://www.oracle.com/technology/global/cn/software/products/ias/htdocs/101320bi.html 以上网页中的 段中file1为8.6的安装文件(包括

Oracle的官网上有它OEM版的Informatica PowerCenter 8.6，支持以SQL Server数据库作为service master db:http://www.oracle.com/technology/global/cn/software/products/ias/htdocs/101320bi.html 以上网页中的 段中file1为8.6的安装文件(包括