Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Mapping Outputs
  6. Generate a Mapping from an SQL Query
  7. Dynamic Mappings
  8. How to Develop and Run a Dynamic Mapping
  9. Dynamic Mapping Use Cases
  10. Mapping Administration
  11. Export to PowerCenter
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Row Indicators

Row Indicators

The first column in the reject file is the row indicator. The row indicator is a flag that defines the update strategy for the data row.
The following table describes the row indicators in a reject file:
Row Indicator
Meaning
Rejected By
0
Insert
Writer or target
1
Update
Writer or target
2
Delete
Writer or target
3
Reject. Marked for reject by an update strategy expression.
Writer
4
Rolled-back insert
Writer
5
Rolled-back update
Writer
6
Rolled-back delete
Writer
7
Committed insert
Writer
8
Committed update
Writer
9
Committed delete
Writer
The following sample reject file shows the row indicator of "0" for each row that indicates an insert update strategy for the row:
0,D,1921,D,Nelson,D,William,D,415-541-5145,D 0,D,1922,D,Page,D,Ian,D,415-541-5145,D 0,D,1923,D,Osborne,D,Lyle,D,415-541-5145,D 0,D,1928,D,De Souza,D,Leo,D,415-541-5145,D 0,D,2001123456789,O,S. MacDonald,D,Ira,D,415-541-514566,T

0 COMMENTS

We’d like to hear from you!