Row Number TransformationThe Row Number Transformation calculates a row number for each row, and adds this as a new output column to the data flow | |
Download |
Row Number Transformation Ranking & Summary
Advertisement
- License:
- Freeware
- Publisher Name:
- Konesans Ltd
- Operating Systems:
- Windows All
- File Size:
- 566 KB
Row Number Transformation Tags
- data transformation row joiner Transformation generate row Row Number number sequence generate key Row flow Row Count Set Row Height Convert row remove blank row blank row remover row as text insert row add row excel remove row short row row calculator reduce matrice row row deleter number transformation Home Row Seven Transformation Pack count row row counter Alternate Row N-TH ROW excel conditional row delete row table header transformation data converting blobshop 5-in-a-row logic games four in a row five row 4-in-a-row five in a row crack wep key minitab for mac data entry speed filemanager nokia n70 transformation math front row first row sports
Row Number Transformation Description
The Row Number Transformation will alculate a row number for each row, and adds this as a new output column to the data flow. The column number is a sequential number, based on a seed value. Each row receives the next number in the sequence, based on the defined increment value. The final row number can be stored in a variable for later analysis, and can be used as part of a process to validate the integrity of the data movement. The Row Number transform has a variety of uses, such as generating surrogate keys, or as the basis for a data partitioning scheme when combined with the Conditional Split transformation. Requirements: ■ SQL Server 2005 Integration Services
Row Number Transformation Related Software