informatica powercenter使用手册

54110108270551782705982100085InformaticaPowerCenter7.120051542201082705517827059821000851.InformaticaPowerCenter.......................................................31.1InformaticaRepositoryServerInformaticaServer..............................................................31.2.......................................................................................................................................31.3Folder........................................................................................................................................32.Informatica................................................................................................33.InformaticaPowerCenter.....................................................................54.Step1Designer.........................................................................55.Step2Folder........................................................................................................76.Step3................................................................................................77.Step4...................................................................................................108.Step5Mapping.................................................................................................119.Step6:Workflow..............................................................................................1610.Step7Workflow...............................................................................................2011.Step8.........................................................................................21543301082705517827059821000851.InformaticaPowerCenter1.1InformaticaRepositoryServerInformaticaServerInformaticaRepositoryServer1WindowsInformaticaRepositoryServerInformaticaServer2UNIXRepositoryServerRepServerpmrepserverInformaticaServerServerpmserver1.2RepositoryServerAdministrationConsole1.3FolderRepositoryManagerFolder2.InformaticaInformatica554440108270551782705982100085545501082705517827059821000853.InformaticaPowerCenterPowerCenterDesignerWorkflowManagerWorkflowMonitor4.Step1Designer54660108270551782705982100085SQL_Test1connect2connect547701082705517827059821000855.Step2FolderRepositoryManagerFolderFolder1Folder2Folderopen3FolderOPEN6.Step3Folder54880108270551782705982100085Workspace_1SourceAnalyzer:SourceAnalyzerSourceAnalyzer,XML,COBOL,ApplicationWarehouseDesinger:WarehuseDesignerWarehouseDesigner,,XMLTransformationDeveloper:TransformationDeveloperTransformationDeveloperMappletDesigner:MappletDesignerMappletDesignermappletMappletMappingDesigner:MappingDesignerMappingDesignermappingmappingSourceAnalyzerWarehouseDesingerTransformationDeveloperMappletDesignerMappingDesigner549901082705517827059821000851SourceAnalyzerRDBMSFlatfileCobolfileXMLfileERPSAPRDBMSExcelODBCODBCRDBMSWorkspace_2SourceAnalyzer2SourceAnalyzerSourcesCreate5410100108270551782705982100085DatabasetypeTablenameCreateDoneEditColumn7.Step4Workspace_1WarehouseDesingerWorkspace_2SourcesTargets6Step42TargetsGenerate/ExecuteSQL…5411110108270551782705982100085SQLGenerateandexecute8.Step5MappingMappingMappingETLETLMappingInformaticaPowerCenter20100MappingCustomerCUST_IDCUST_NAMEODS_CUSTOMER_ACTIVECustomer.CUST_Name_AAODS_Customer.CUST_NameCUST_NameCUST_Name_OUTCUST_NameSourceQualifierCUST_Name||’_AA’1MappingDesigner2MappingDesignerTransformationCreate5412120108270551782705982100085”Selecttransformationtype”ExpressionEXP_Cust_Name3CUST_Name4Ports5413130108270551782705982100085Workspace_3Workspace_31PortCUST_NAME_OUTCUST_NAMECUST_NAME_OUTWorkspace_3Workspace_32Workspace_4Workspace_454141401082705517827059821000855CUST_NAME_OUTCUST_NAME6SQLQualifierODS_CUSTOMER_ACTIVEInformaticaMappingDesigner5415150108270551782705982100085AutolinkFromSQ_CUSTOMERToODS_CUSTOMER_ACTIVEByNamePositionNameApplyNowMapping54161601082705517827059821000857MappingStep6WorkflowETL9.Step6:WorkflowFolderStep1Step2Workflow1)SessionMapping2)3)SessionMappingWorkspace_5TaskDeveloper:TaskDeveloper(Tasks)5417170108270551782705982100085Session-MappingCommand-WorkflowEmail-WorkflowemailWorkletDesigner:WorkletDesignerWorkletWorkflowWorkflowDesigner:WorkflowDesignerWorkflowInformaticaServer1WorkflowDesignerWokflow2WorkflowWorkflowWizardWorkflowWorkflowInformaticaServerWorkflowMapping5418180108270551782705982100085Workflow54191901082705517827059821000853Informatica_Training_Chinese4SessionWorkflowDesigner2Sessions_m_test1Edit5420200108270551782705982100085Wokspace_6Workspace_6MappingSourceTarget2sql_sdbu325TaskInformatica_Training_Chinese10.Step7WorkflowStartWorkflow5421210108270551782705982100085Step811.Step85422220108270551782705982100085Workspace_8workflowmonitorGanttChartTaskViewWorkspace_8Task_Views_m_test15423230108270551782705982100085SessionLogs_m_test1GetSessionLogSessionLogInformatica