How to get that Short Name column and write it to flat file.....?

Sorry for Inconveniences

in detail....

i am having a flat file having column Insurer-Dimension-key

i am having a table "Insurer_Dim" having column Insurer Key , Insurer Short Name , where insurer...

my flat file contains a column name as Insurer-Dimension-key which is foreign key to the table insurer_Dim

now i am doing look up using this Insurer_Dim

in final destination, instead...