Hi,

I have input file with three fields
Cust Id, Name, State

How do I load into target table with all the three fields into one field.

Target table is Customer
Field CustInfo (Cust Id + Name + State)

I am using Data Migrator 7.4 on HP Unix.

Thanks

Kartik

I haven't used data migrator, but you should be able to do a define or a compute. The field size needs to be equal to the sum of the three input fields plus 2.
DEFINE FILE yourfile
CUSTINFO/A200=CUST_ID||(' '|NAME)||(' '|STATE);
END

Research how to use the Transformation Calculator. How to do concatenation is listed with that.

Good luck.

Jessica Bottone