LineageID:
- It’s an integer pointer to the column within the buffers
- In Data Flow every column has atleast one LineageID.
- A column can have more than one LineageID. This is because when column passes through various transformation outputs in a Data Flow, it holds the pointer to the column in a buffer in data flow. In the below image you can see the column EmpNo (Sort Input) has a LineageID: 58
Image 1: LineageID for the EmpNo column in a Sort Input
Image 2: LineageID for the EmpNo column in a Sort Output is different
Posted by shahharsh

