Skip to Content

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

Capture.PNG

2 Comments
You must be Logged on to comment or reply to a post.
    • 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.