Categories Uncategorized How to maintain surrogate key in Flat File!! May 6, 2014 | 15 Views | Sagar Girme more by this author SAP Data Services share share tweet share Follow How to maintain sequence/ artificial sequence keys/ surrogate key column in a file which is maintaining data on daily basis with upending new data. (No deletion of old records) Find attached .atl file for the same. DF name: Key_Generation_In_FF Alert Moderator To report this post you need to login first. 2 Replies 2 Comments You must be Logged on to comment or reply to a post. Michael vasanth May 7, 2014 at 1:29 am Hi sagar, Could you please attach the source files like (0) Sagar Girme Post authorMay 7, 2014 at 6:19 am 1. Main source file is simple .xlsx file EM_NO EM_Name Department Grade 1 Ram SAP A 2 Sham EIM B 3 Geeta Testing A 4 Seeta BFS C 5 Anil ManLog B 6 Sunil NSS A 7 Amit IT C 8 Rohit HR B 2. All others are .txt files which will be blank initially. like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.