informatica_常用组件使用方法

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

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

2、edCallsaprocedureinasharedlibraryorDLL.ExpressionPassive/ConnectedCalculatesavalue.ExternalProcedurePassive/ConnectedorUnconnectedCallsaprocedureinasharedlibraryorintheCOMlayerofWindows.FilterActive/ConnectedFiltersdata.HTTPTransformationPassive/ConnectedConnectstoanHTTPservertoread

3、orupdatedata.InputPassive/ConnectedDefinesmappletinputrows.AvailableintheMappletDesigner.JavaActiveorPassive/ConnectedExecutesuserlogiccodedinJava.Thebytecodefortheuserlogicisstoredintherepository.JoinerActive/ConnectedJoinsdatafromdifferentdatabasesorflatfilesystems.LookupPassive/C

4、onnectedorUnconnectedLooksupvalues.NormalizerActive/ConnectedSourcequalifierforCOBOLsources.Canalsouseinthepipelinetonormalizedatafromrelationalorflatfilesources.OutputPassive/ConnectedDefinesmappletoutputrows.AvailableintheMappletDesigner.RankActive/ConnectedLimitsrecordstoatoporbo

5、ttomrange.RouterActive/ConnectedRoutesdataintomultipletransformationsbasedongroupconditions.SequenceGeneratorPassive/ConnectedGeneratesprimarykeys.SorterActive/ConnectedSortsdatabasedonasortkey.SourceQualifierActive/ConnectedRepresentstherowsthattheIntegrationServicereadsfromarelati

6、onalorflatfilesourcewhenitrunsasession.SQLActiveorPassive/ConnectedExecutesSQLqueriesagainstadatabase.StoredProcedurePassive/ConnectedorUnconnectedCallsastoredprocedure.TransactionControlActive/ConnectedDefinescommitandrollbacktransactions.UnionActive/ConnectedMergesdatafromdifferen

7、tdatabasesorflatfilesystems.UpdateStrategyActive/ConnectedDetermineswhethertoinsert,delete,update,orrejectrows.XMLGeneratorActive/ConnectedReadsdatafromoneormoreinputportsandoutputsXMLthroughasingleoutputport.XMLParserActive/ConnectedReadsXMLfromoneinputportandoutputsdatatooneormore

8、outputports.XMLSour