FDMEE Data load mapping using SQL script
Hi,
We are getting a csv file from the source and are using a SQL script to map the data.
We generally write a simple case condition to map the data and it creates a query (update tdataseg_t set UD4X(column) )= and takes our script.
Is it possible to give a different query all together because i wont be able to achieve my mapping by using a update statement. i might have to use a merge option and update column