Modifying Data - Informatica

When the Debugger pauses, the current instance displays in the Instance window, and the current instance indicator displays on the transformation in the mapping. You can make the following modifications to the current instance when the Debugger pauses on a data breakpoint:

  • Modify output data. You can modify output data of the current transformation. When you continue the session, the Integration Service validates the data. It performs the same validation it performs when it passes data from port to port in a regular session.
  • Change null data to not-null. Clear the null column, and enter a value in the value column to change null data to not-null.
  • Change not-null to null. Select the null column to change not-null data to null. The Designer prompts you to confirm that you want to make this change.
  • Modify row types. Modify Update Strategy, Filter, or Router transformation row types.

For Router transformations, you can change the row type to override the group condition evaluation for userdefined groups. For example, if the group condition evaluates to false, the rows are not passed through the output ports to the next transformation or target. The Instance window displays <no data available>, and the row type is filtered. If you want to pass the filtered row to the next transformation or target, you can change the row type to Insert. Likewise, for a group that meets the group condition, you can change the row type from insert to filtered.

After you change data, you can refresh the cache before you continue the session. When you issue the Refresh command, the Designer processes the request for the current transformation, and you can see if the data you enter is valid. You can change the data again before you continue the session.

Restrictions

You cannot change data for the following output ports:

  • Normalizer transformation. Generated Keys and Generated Column ID ports.
  • Rank transformation. RANKINDEX port.
  • Router transformation. All output ports.
  • Sequence Generator transformation. CURRVAL and NEXTVAL ports.
  • Lookup transformation. NewLookupRow port for a Lookup transformation configured to use a dynamic cache.
  • Custom transformation. Ports in output groups other than the current output group.
  • Java transformation. Ports in output groups other than the current output group.

Additionally, you cannot change data associated with the following:

  • Mapplets that are not selected for debugging
  • Input or input/output ports
  • Output ports when the Debugger pauses on an error breakpoints

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics