Informatica ETL：如何从导出的XML文件中确定目标数据库名称

If your <TARGET> tag lacks complete database attributes, don’t worry—Informatica’s export XML stores target connection details in related nodes, not always directly on the TARGET itself. Here are the most reliable ways to track down the target database name:

• Check associated <SESSION> nodes
  Every ETL job’s session (the executable unit) links to the target connection. Look for <SESSION> tags in your XML, and check for attributes like DBDNAME (directly gives the database name) or CONNECTION_NAME (points to a pre-defined connection). For example:

  <SESSION NAME="S_Load_GL_Lines_Target" DBDNAME="PROD_FINANCE" CONNECTION_NAME="Target_Oracle_Conn" OBJECTVERSION="1" ...>
  

  The DBDNAME here is your target database.

• Locate <CONNECTIONS> definitions
  If you find a CONNECTION_NAME in the session, search the XML for a <CONNECTIONS> tag with that name. This node will explicitly list the target database details:

  <CONNECTIONS NAME="Target_Oracle_Conn" DBDNAME="PROD_FINANCE" DATABASETYPE="Oracle" OWNERNAME="FIN_USER" ...>
  

• Look for <TARGET_DEFINITION> nodes
  Target tables often reference a formal target definition. Search for <TARGET_DEFINITION> tags that match your <TARGET>'s NAME attribute. These definitions typically include DBDNAME and OWNERNAME for the target database:

  <TARGET_DEFINITION NAME="GL_LINES_TARGET" DBDNAME="PROD_FINANCE" OWNERNAME="FIN_USER" DATABASETYPE="Oracle" ...>
  

• Search all DBDNAME attributes
  Do a full search of the XML for the DBDNAME attribute (excluding your source database's value). The remaining DBDNAME entries are likely tied to your target connection or definition.

A quick tip: Informatica's export XML is structured to link objects (mappings, sessions, connections) by name, so cross-referencing the <TARGET>'s name with related session/definition nodes will usually lead you to the database details.

内容的提问来源于stack exchange，提问作者jshen