Informatica 常用组件使用方法.doc

《Informatica 常用组件使用方法.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

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

2、CallsaprocedureinasharedlibraryorDLL.ExpressionPassive/ConnectedCalculatesavalue.ExternalProcedurePassive/ConnectedorUnconnectedCallsaprocedureinasharedlibraryorintheCOMlayerofWindows.FilterActive/ConnectedFiltersdata.HTTPTransformationPassive/ConnectedConnectstoanHTTPservertoreadorup

3、datedata.InputPassive/ConnectedDefinesmappletinputrows.AvailableintheMappletDesigner.JavaActiveorPassive/ConnectedExecutesuserlogiccodedinJava.Thebytecodefortheuserlogicisstoredintherepository.JoinerActive/ConnectedJoinsdatafromdifferentdatabasesorflatfilesystems.LookupPassive/Connect

4、edorUnconnectedLooksupvalues.NormalizerActive/ConnectedSourcequalifierforCOBOLsources.Canalsouseinthepipelinetonormalizedatafromrelationalorflatfilesources.OutputPassive/ConnectedDefinesmappletoutputrows.AvailableintheMappletDesigner.RankActive/ConnectedLimitsrecordstoatoporbottomrang

5、e.RouterActive/ConnectedRoutesdataintomultipletransformationsbasedongroupconditions.SequenceGeneratorPassive/ConnectedGeneratesprimarykeys.SorterActive/ConnectedSortsdatabasedonasortkey.SourceQualifierActive/ConnectedRepresentstherowsthattheIntegrationServicereadsfromarelationalorflat

6、filesourcewhenitrunsasession.SQLActiveorPassive/ConnectedExecutesSQLqueriesagainstadatabase.StoredProcedurePassive/ConnectedorUnconnectedCallsastoredprocedure.TransactionControlActive/ConnectedDefinescommitandrollbacktransactions.UnionActive/ConnectedMergesdatafromdifferentdatabasesor

7、flatfilesystems.UpdateStrategyActive/ConnectedDetermineswhethertoinsert,delete,update,orrejectrows.XMLGeneratorActive/ConnectedReadsdatafromoneormoreinputportsandoutputsXMLthroughasingleoutputport.XMLParserActive/ConnectedReadsXMLfromoneinputportandoutputsdatatooneormoreoutputports.XM

8、LSour