informatica 常用组件使用方法

《informatica 常用组件使用方法》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、常用组件使用方法表1中列出的是informatica中的所有组件。不会在本文档中出现的会在组件名后标出。表1AggregatorActive/ConnectedPerformsaggregatecalculations.ApplicationSourceQualifierActive/ConnectedRepresentstherowsthattheIntegrationServicereadsfromanapplication,suchasanERPsource,whenitrunsasession.CustomActiveor

2、Passive/ConnectedCallsaprocedureinasharedlibraryorDLL.ExpressionPassive/ConnectedCalculatesavalue.ExternalProcedurePassive/ConnectedorUnconnectedCallsaprocedureinasharedlibraryorintheCOMlayerofWindows.FilterActive/ConnectedFiltersdata.HTTPTransformationPassive/Connect

3、edConnectstoanHTTPservertoreadorupdatedata.InputPassive/ConnectedDefinesmappletinputrows.AvailableintheMappletDesigner.JavaActiveorPassive/ConnectedExecutesuserlogiccodedinJava.Thebytecodefortheuserlogicisstoredintherepository.JoinerActive/ConnectedJoinsdatafromdiffer

4、entdatabasesorflatfilesystems.LookupPassive/ConnectedorUnconnectedLooksupvalues.NormalizerActive/ConnectedSourcequalifierforCOBOLsources.Canalsouseinthepipelinetonormalizedatafromrelationalorflatfilesources.OutputPassive/ConnectedDefinesmappletoutputrows.Availableinth

5、eMappletDesigner.RankActive/ConnectedLimitsrecordstoatoporbottomrange.RouterActive/ConnectedRoutesdataintomultipletransformationsbasedongroupconditions.SequenceGeneratorPassive/ConnectedGeneratesprimarykeys.SorterActive/ConnectedSortsdatabasedonasortkey.SourceQualifie

6、rActive/ConnectedRepresentstherowsthattheIntegrationServicereadsfromarelationalorflatfilesourcewhenitrunsasession.SQLActiveorPassive/ConnectedExecutesSQLqueriesagainstadatabase.StoredProcedurePassive/ConnectedorUnconnectedCallsastoredprocedure.TransactionControlActive

7、/ConnectedDefinescommitandrollbacktransactions.UnionActive/ConnectedMergesdatafromdifferentdatabasesorflatfilesystems.UpdateStrategyActive/ConnectedDetermineswhethertoinsert,delete,update,orrejectrows.XMLGeneratorActive/ConnectedReadsdatafromoneormoreinputportsandoutp

8、utsXMLthroughasingleoutputport.XMLParserActive/ConnectedReadsXMLfromoneinputportandoutputsdatatooneormoreoutputports.XMLSour