2013年12月_thy822

12月 10月 05月 04月 03月 02月 01月

转载日期维表数据生成方法（Oracle方式）

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

2013-12-13 10:03:13 2544

原创 GENERATE DATE / TIME DIMENSION IN INFORMATICA

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

2013-12-13 09:40:17 1382 1

转载 INFORMATICA2

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

2013-12-12 16:53:29 1356

转载 INFORMATICA1

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

2013-12-12 16:26:31 1906

转载 INCREMENTAL AGGREGATION IN INFORMATICA

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

2013-12-12 15:37:55 764

转载增量聚集

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

2013-12-12 14:58:05 813

转载 Informatica Powercenter调优

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

2013-12-06 11:49:37 2483

转载 Informatica中实现count(distinct)

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

2013-12-04 15:59:56 2076

DEFINE MEASURE 'Internet Sales'[Internet Total Sales] = SUM('Internet Sales'[Sales Amount]) EVALUATE SUMMARIZECOLUMNS ( 'Date'[Calendar Year], TREATAS({2013, 2014, 2015}, 'Date'[Calendar Year]), "Total Sales", [Internet Total Sales], "Combined Years Total Sales", CALCULATE([Internet Total Sales], ALLSELECTED('Date'[Calendar Year])), "ABC", SUMX('Internet Sales', 'Internet Sales'[Sales Amount]) / CALCULATE(SUM('Internet Sales'[Sales Amount]), ALLSELECTED('Date'[Calendar Year])) ) ORDER BY [Calendar Year]

2020-06-21

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

thy822的专栏

转载日期维表数据生成方法（Oracle方式）

原创 GENERATE DATE / TIME DIMENSION IN INFORMATICA

转载 INFORMATICA2

转载 INFORMATICA1

转载 INCREMENTAL AGGREGATION IN INFORMATICA

转载增量聚集

转载 Informatica Powercenter调优

转载 Informatica中实现count(distinct)

ssas5部署与管理.rar

powercenter使用教程.doc

20120926-Informatica_Hello_World_Program.rar

sqlserver2008sql.rar

MSTR Admin

MSTR_AdvancedReporting

Teradata Physical

MicroStrategy 英文教程

空空如也