Skip to Content
Author's profile photo Sagar Girme

How to maintain surrogate key in Flat File!!

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


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Michael vasanth
      Michael vasanth

      Hi sagar,

                   Could you please attach the source files

      Author's profile photo Sagar Girme
      Sagar Girme
      Blog Post Author

      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.