Conversion Using Data Flow Analysis Input File
PC to Cloud Conversion ignores the conversion of duplicate mappings by using a Data Flow Analysis (DFA) input file. You can specify the data flow analysis input file for the PC to Cloud Conversion service properties.
The DFA assessment report includes the duplicate mapping cluster list. PC to Cloud Conversion skips the conversion of mappings marked as duplicate. PC to Cloud Conversion converts only the mapping marked as original in the DFA input file. After conversion, the sessions converts to mapping tasks that points to an original mapping instead of a duplicate mapping.
The original and duplicate mappings have the same source, targets, transformations including a mapplet transformation, links, and mapping parameters. To use the DFA input file for PC to Cloud Conversion, ensure that the same PowerCenter XML file includes the names of the original and duplicate mappings.
Note: PC to Cloud Conversion cannot be used to ignore duplicate mapplets.
Sample Input File for Data Flow Analysis
Use the following file format in the data flow analysis input file:
TYPE|REPOSITORY_NAME|FOLDER_NAME|WORKFLOW_NAME|WORKLET_NAME|SESSION_NAME|MAPPING_NAME
where the Type can be either Original or Duplicate.
The following example shows a sample data flow analysis input file:
Original|QAPCRS|DFA|wf_m_DFA_SimpleSrcTrg_1||s_m_DFA_SimpleSrcTrg_1|m_DFA_SimpleSrcTrg_1
Duplicate|QAPCRS|DFA|wf_m_DFA_SimpleSrcTrg_2||s_m_DFA_SimpleSrcTrg_2|m_DFA_SimpleSrcTrg_2
Duplicate|QAPCRS|DFA|wf_m_DFA_SimpleSrcTrg_3||s_m_DFA_SimpleSrcTrg_3|m_DFA_SimpleSrcTrg_3