Thank you very much, I have implemented using both tmap and tuniqrow, but I have one scenario where I am working with key-value-timestamp thing, if there is any change in database field then related file (for the Database field) only update not all the files (like in my example 2 files are there)
empfile
EmpID FirstName LastName TimeStamp
1 AB P 01/27/2016 2.29AM
2 CD Q 01/27/2016 2.29AM
3 EF R 01/27/2016 2.29AM
4 GH S 01/27/2016 2.29AM
5 IJ T 01/27/2016 2.29AM
split using tmap
file1 (empid,firstname,timestamp)
file2 (empid,lastname,timestamp)
if there is any change in lastname then new record will append only in file2 not in file1.
also same if there is any change in firstname then new record will append only in file1 not in file2.