Informatica
xiadingling
天道酬勤
展开
-
Active Lookup Transformation – Learn its usage and configuration steps
Active Lookup transformation has been evidently useful in power center from a long time. As we all aware that Power center 9 releases has upgraded lookup transformation to active, i.e it can ret转载 2016-06-06 16:49:59 · 359 阅读 · 0 评论 -
BOOST lookup performance
IntroductionLookups are expensive in terms of resources and time.A set of tips about how to setup lookup transformations would dramatically improve the main constrains such as time and perform转载 2016-06-03 17:45:36 · 485 阅读 · 0 评论 -
Master Outer Join in Informatica
Four types of joins in Informatica1) Normal Join – Normal join discards all the rows of data from the master and detail source that do not match, based on the condition.2) Master Join – Master out转载 2016-06-03 11:32:54 · 3718 阅读 · 0 评论 -
using multiple parameter files in informatica
You must follow below steps, or you will be failed.Workflow and Session Level Parameter FileWhen we define a workflow parameter file and a session parameter file for a session within the workflow,转载 2016-04-08 14:36:35 · 668 阅读 · 0 评论 -
Finding all mappings that use a table as source, target and lookups
If you are using version 7.x, this query will get you list of all the mappings that use the table as source, target and lookup. You need to change the 'FOLDER_NAME' filter value, or remove it.转载 2016-04-08 16:08:21 · 378 阅读 · 0 评论 -
find a list of mapping affect special talbe in informatica
Informatica metadata repository stores and maintains information about all the objects in Informatica.So , you have to write an external query to find this : SELECT SUBJECT_AREA , MAPPING_NAM转载 2016-04-08 15:54:30 · 387 阅读 · 0 评论 -
parameter in Inforamtica
Stop Hardcoding- Follow Parameterization Technique Details Written by Saurav Mitra Category: Informatica Last Updated: 16 September 2014Hits: 24148 This a转载 2016-04-08 14:33:00 · 1168 阅读 · 0 评论 -
拖拽Imformatica Repository Navigator
1、将Repository Navigator 窗口脱离默认工作窗口平台右键单击"Repository Navigator"窗口的空白处—>"Allow Docking"—>拖拽出默认工作窗口2、将独立的Repository Navigator 窗口放回原状态右键单击"Repository Navigator"窗口的空白处—>"Allow Docking"—>把原创 2016-02-04 10:01:30 · 937 阅读 · 0 评论 -
Lookup Transformation(4) 可配置的特性
Lookup Transformation Properties Lookup组件有很多的可配置的特性。 决定于查找的数据源(文件或者关系型数据库)Lookup transformation has so many proprties which you can configure. Depending on the lookup source (flat file翻译 2016-01-05 17:34:44 · 567 阅读 · 0 评论 -
Lookup Transformation(3) changes in informatica version 9
Lookup Transformation is ActiveOne of the changes that made in informatica version 9 was making the lookup transformation as active transformation. The lookup transformation canreturn翻译 2016-01-05 17:21:57 · 400 阅读 · 0 评论 -
Lookup Transformation(2) 优化
Tuning Lookup Transformation - Informatica Q) How to tune lookup transformation to improve the performance of the mapping?This is a frequently asked question in informatica interview翻译 2016-01-05 16:41:35 · 391 阅读 · 0 评论 -
Joiner Transformation(1)
The joiner transformation is an active and connected transformation used to join two heterogeneous sources. The joiner transformation joins sources based on a condition that matches one or more翻译 2016-01-05 14:24:07 · 556 阅读 · 0 评论 -
Joiner transformation(2) 优化
Joiner transformation 使用注意点:1)使用场景: 不同数据源( 异构源)2)Join type: Normal Join, Master Outer Join, Detail Outer Join or Full Outer Join.3) 用行数少的重复记录少的表为 master, 反之为detail4) 对输入项做排序5) 理解 blocking t翻译 2016-01-05 14:48:16 · 504 阅读 · 0 评论 -
Lookup Transformation (1)
Lookup Transformation Lookup transformation is used to look up data in a flat file, relational table, view or synonym. Lookup is a passive/active transformation and can be used in both connected翻译 2016-01-05 16:16:25 · 437 阅读 · 0 评论 -
informatica 基本组件使用说明
http://blog.itpub.net/29144194/viewspace-1141535/1. INFORMATICA CLIENT的使用1.1 Repository Manager 的使用1.1.1 创建Repository。前提: a. 在ODBC数据源管理器中新建一个数据源连接至你要创建Repository的数据库(例:jzjxdev)b. 要转载 2016-01-05 11:53:33 · 20973 阅读 · 0 评论 -
How to Tune Performance of Informatica Lookup Transformation
How to Tune Performance of Informatica Lookup Transformation Details Written by Akash Mitra Category: Informatica Last Updated: 16 September 2014Hits: 29340 To m转载 2016-09-20 14:50:58 · 799 阅读 · 0 评论