informatica 常用组件使用方法

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

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

2、ive/ConnectedCallsaprocedureinasharedlibraryorDLL.ExpressionPassive/ConnectedCalculatesavalue.ExternalProcedurePassive/ConnectedorUnconnectedCallsaprocedureinasharedlibraryorintheCOMlayerofWindows.FilterActive/ConnectedFiltersdata.HTTPTransformationPassive/ConnectedConnec

3、tstoanHTTPservertoreadorupdatedata.InputPassive/ConnectedDefinesmappletinputrows.AvailableintheMappletDesigner.JavaActiveorPassive/ConnectedExecutesuserlogiccodedinJava.Thebytecodefortheuserlogicisstoredintherepository.JoinerActive/ConnectedJoinsdatafromdifferentdatabases

4、orflatfilesystems.LookupPassive/ConnectedorUnconnectedLooksupvalues.NormalizerActive/ConnectedSourcequalifierforCOBOLsources.Canalsouseinthepipelinetonormalizedatafromrelationalorflatfilesources.OutputPassive/ConnectedDefinesmappletoutputrows.AvailableintheMappletDesigner

5、.RankActive/ConnectedLimitsrecordstoatoporbottomrange.RouterActive/ConnectedRoutesdataintomultipletransformationsbasedongroupconditions.SequenceGeneratorPassive/ConnectedGeneratesprimarykeys.SorterActive/ConnectedSortsdatabasedonasortkey.SourceQualifierActive/ConnectedRep

6、resentstherowsthattheIntegrationServicereadsfromarelationalorflatfilesourcewhenitrunsasession.SQLActiveorPassive/ConnectedExecutesSQLqueriesagainstadatabase.StoredProcedurePassive/ConnectedorUnconnectedCallsastoredprocedure.TransactionControlActive/ConnectedDefinescommita

7、ndrollbacktransactions.UnionActive/ConnectedMergesdatafromdifferentdatabasesorflatfilesystems.UpdateStrategyActive/ConnectedDetermineswhethertoinsert,delete,update,orrejectrows.XMLGeneratorActive/ConnectedReadsdatafromoneormoreinputportsandoutputsXMLthroughasingleoutputpo

8、rt.XMLParserActive/ConnectedReadsXMLfromoneinputportandoutputsdatatooneormoreoutputports.XMLSour