INFORMATICA
文章平均质量分 69
吃鱼的羊
这个作者很懒,什么都没留下…
展开
-
ERROR: Partitioning option license required to run sessions with user-defined partition points.
I have created a session in which I have added an aggregator. When I select the "Sorted Input" property, I get the following error:ERROR: Partitioning option license required to run sessions with u原创 2015-06-30 12:34:16 · 1079 阅读 · 0 评论 -
(转)informatica 面试题大全
1 What is the difference between a data warehouse and a data mart?Ø Dataware house:It is a collection of data marts. Represents historical data. a data warehouse is a relational database which is转载 2015-07-07 12:55:12 · 5870 阅读 · 0 评论 -
增量加载的几种方案
1,数据源的时间列Update_Date>SYSDATE-12,数据源的时间列Update_Date> > '$$INCREMENT_TS' ,INCREMENT_TS保存在Target DB或者INFA Repository DB中: SETVARIABLE($$INCREMENT_TS,SESSSTARTTIME)原创 2015-07-07 11:04:39 · 2726 阅读 · 0 评论 -
Source Qualifier Transformation
当Source Qualifier Transformation使用sql query override的话,必须所有的ports必须连接到downstream,否则报错, Source Qualifier Transformation支持Oracle分析函数 比如:(LKP Transformation不支持)SELECT WC_POSTN_COACH_A_TEST1.ORG_W原创 2015-07-01 17:57:26 · 876 阅读 · 0 评论 -
DAC
DAC开发:Table, Index, (Refresh Date)Task, Subject Area, Execution PlanSource System Parameter($$KPI_CUT_DAYS)建bitmap索引的字段通常就固定的几个值,如果更改了数据,最好重建一下,这与索引类型有关 更新数据量大的话(bulk load)需要重建索引(index),否则原创 2015-07-12 11:54:29 · 795 阅读 · 0 评论 -
INFA Linux 环境配置
/home/infa/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup programsexport ORACLE_BASE=/op原创 2015-08-06 11:52:18 · 1273 阅读 · 0 评论 -
File Target Writer
可生成xls(tab键分隔),csv(逗号分隔),txt (或者任何自命名后缀的文件)header.sh内容:excel文件:echo -en "ORG_WID\tMONTH_WID\tDSM_POSTN_WID\tSR_POSTN_WID\tPOINT_AVE\tPOINT_SCOPE\tCOACH_TYPE_CD\r\n"csv文件:echo -en "ORG_WID,MONTH_原创 2015-07-02 17:32:16 · 386 阅读 · 0 评论 -
Importing a Microsoft Excel Source Definition
Importing a Microsoft Excel Source Definition#PowerCenter treats a Microsoft Excel source as a relational database, not a flat file. Like relational sources, the Designer uses ODBC to import a M转载 2015-08-21 16:01:37 · 316 阅读 · 0 评论 -
Informatica Connection Objects
1,Oracle Connection Object/opt/oracle/product/11g/network/admin/tnsnames.oraSEUATW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracnbj019)(PORT = 1521))原创 2015-12-21 16:45:24 · 706 阅读 · 0 评论 -
浅析ODS与EDW关系(转载)
摘要本文重点介绍了企业运营数据仓储(ODS)和企业数据仓库(EDW )的概念,并对ODS与EDW 之间的关系,包括两者相同点与不同点进行了详尽的对比与阐述,文章还对业界公认的ODS和EDW 两种不同建设方法也分别进行了说明,并给出了作者认为合理的建设方法。1 前言ODS(运营数据仓储)与EDW(企业数据仓储)都是中国电信企业数据架构的重要组成部分,它们一起构成企业统一数据平转载 2016-03-01 12:50:00 · 3833 阅读 · 0 评论 -
SQL Transformation
如果你比较擅长写SQL,可以使用SQL TransformationWhen you create an SQL transformation, you configure the following options:¨ Mode. The SQL transformation runs in one of the following modes:Script mode. The SQ原创 2015-07-08 17:41:26 · 1303 阅读 · 0 评论 -
INFA Transformation组件
RouterRouter和Filter很相似,Router可以用一或多个Filter来取代,不同的是用Router来生成多个组时输入数据只需处理一次,所以效率更高;Router 由一个输入组,一到多个用户定义的输出组和一个默认组组成,每一个用户定义的输出组含一个测试条件,满足条件的输入数据会进入相应的用户定义组,不满足所有用户定义条件的数据会进入默认组;输入组和输出组的端口类型和名称相同;原创 2016-03-24 11:59:59 · 864 阅读 · 0 评论 -
Workflow Manager导航窗口不见了,如何恢复
After undocking the Repository Navigator, the Navigator window can be dragged and placed anywhere within Workflow Manager. However, sometimes it gets hidden.So if you want to get back this, do the转载 2016-09-30 16:34:59 · 1251 阅读 · 0 评论 -
Local Variables
Use local variables in Aggregator, Expression, and Rank transformations.You might use variables to complete the following tasks:¨ Temporarily store data.¨ Simplify complex expressions.¨ Sto原创 2015-07-03 17:14:27 · 506 阅读 · 0 评论 -
Pipeline Partitioning
A pipeline consists of a source qualifier and all the transformations and targets that receive data from that source qualifier.You can set the following attributes to partition a pipeline:¨ Partit原创 2015-07-09 17:55:41 · 455 阅读 · 0 评论 -
INFA各类变量
1,Parameter and Variable Types:Service variables: $PMSuccessEmailUser, $PMSessionLogCount, and $PMSessionErrorThreshold等等Service process variables: $PMRootDir, $PMSessionLogDir, a原创 2015-07-13 17:26:46 · 1192 阅读 · 0 评论 -
缓慢变化维抽取方案
他INFORMATICA提供三种SCD Dimension抽取Mapping Wizard:Type1不保存历史数据,当某些重要字段发生变化,直接更新维度表Type2保存所有历史维度变更Type3只保存当前和最近一次的被替换的维度变更,Target表通常增加类似字段:(上次更新的字段值和上次更新时间)比如:PM_PREV_INTEGRATION_ID,PM_PREV_DATAS原创 2015-07-07 16:22:05 · 444 阅读 · 0 评论 -
sequence-ID in Dynamic Lookup
To create a generated key for a column in the target table, select Sequence-ID in the Associated Expression column. You can associate a generated key instead of an input port for lookup ports wit原创 2015-07-07 15:35:23 · 537 阅读 · 0 评论 -
Stored Procedure Transformation
To use a Stored Procedure transformation, complete the following steps:1. Create the stored procedure in the database.2. Import or create the Stored Procedure transformation.3. Determine whether原创 2015-07-09 12:33:43 · 533 阅读 · 0 评论 -
生成Surrogate Key的几种方案
1)维度表一般使用方法(维度表如果清空重新抽取,代理键可能不一样了,需要重新抽取事实表,建议维度表一般采用更新的方式抽取)取得维度表最大的WID,然后在其基础上累加生成新的代理键插入维度表 2)事实表的数据量很大,代理键的意义也不是很重要,一般用Sequence Generator Transformation去生成代理键。原创 2015-07-02 16:35:14 · 2036 阅读 · 0 评论 -
Workflow Recovery
Task Recovery StrategiesEach task in a workflow has a recovery strategy. When the Integration Service recovers a workflow, it recovers tasks based on the recovery strategy:¨ Restart task. When the原创 2015-07-10 15:58:37 · 537 阅读 · 0 评论 -
Sequence Generator分析
Current Value:3 Increment By:2则初始化 NEXTVAL:3 CURRVAL:3当且仅当 NEXTVAL走一行时,CURRVAL才增加: NEXTVAL+Increment By(如果NEXTVAL没有connect to downstream,则CURRVAL始终停留在3)第一次运行workflow: row原创 2015-07-01 12:38:11 · 1159 阅读 · 0 评论 -
informatica 在抽取EXCEL中遇到问题及INFA售后给出的建议
1.测试环境:服务器:操作系统:windows server 2008 R2 Enterprise (X64)Informatica版本:9.6.1 hotfix1 (x64)MSOffice:Professional2010 (x64)客户端:操作系统:Win7 旗舰版 (x64)Informatica版本:9.6.0 (x86)MS Office:Profes转载 2015-07-03 12:01:15 · 2209 阅读 · 0 评论 -
Normalizer Transformation
1,实现列转行: Generated Key,自动产生不能删除的端口,命名为GK_XXX,由这个端口产生一个序列号值,在需要时可以作为主键,运行成功后会在知识库中保存下一个值,可以在Mapping中看到下一个值,可以修改这个值;Generated Column ID,自动产生不能删除的端口,命名为GCID_,这个端口产生一个序号指名当前输出来自多个输入中的哪一个;Reset和R原创 2015-07-03 12:50:08 · 540 阅读 · 0 评论 -
INFA调优
瓶颈类型 •Source瓶颈•Target瓶颈•Mapping瓶颈•Session瓶颈•System瓶颈Source调优•源为文本文件•调优Line Sequential Buffer Length(1024)•源为关系型数据库•在Source Qualify优化SQL•在源数据增加索引•增加Database network Pa原创 2015-07-13 15:57:52 · 980 阅读 · 0 评论 -
Lookup Transformation
Overriding the Lookup QueryLookup Transformation 的 Lookup Query Override不同于Source Qualifier Transformation的SQL Query:不需要列和Ports数目一样,也不需要顺序一样,只要sql中的as列名完全一致就可以(区分大小写)Lookup Query Override: selec原创 2015-07-02 12:30:03 · 2115 阅读 · 0 评论 -
Aggregator Transformation
The Aggregator is an active transformation that changes the number of rows in the pipeline. The Aggregatortransformation has the following components and options:¨ Aggregate cache. The Integration原创 2015-06-30 10:56:31 · 645 阅读 · 0 评论 -
INFA杂记
1,Update Strategy组件 经常和Lookup组件 IIF(ISNULL(LKP_ROW_WID),'INSERT','UPDATE')2,When you create a session, the Workflow Manager checks the mapping properties. Mappings dynamically pick upchanges to sh原创 2015-07-13 17:12:31 · 661 阅读 · 0 评论 -
Infa元数据查询
--查询使用了哪些onnectionsselectDISTINCT CONNECTION_NAME from REP_SESSION_CNXSwhere SUBJECT_AREA='DW_ORACLE_ETL' select* from REP_SESSION_CNXS where connection_name='mysql_product_singl原创 2016-07-04 11:41:31 · 670 阅读 · 0 评论