I have a Sequential file source and target server job. I am making one column in the target as Key column. But it is easily inserting any duplicate values there.
May I know what is the use of Key column in a sequential file stage?
Key in sequential File
Moderators: chulett, rschirm, roy
None. More of a informational / metadata thing, if anything, for you to mark the 'key' columns. Got nothing at all to do with duplicates on the target side, especially in a sequential target.
You will need to handle / remove the 'duplicates' in the source data in your job design. How you manage that is completely up to you and the nature of the duplicates... stage variables, hashed files, aggregator... there are a number of different techniques.
You will need to handle / remove the 'duplicates' in the source data in your job design. How you manage that is completely up to you and the nature of the duplicates... stage variables, hashed files, aggregator... there are a number of different techniques.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: