Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. 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!