How use an existing transform map for a new import table?

[Rama Chandra D]

Hello,

Can someone tell me how to use an existing transform map on a new import table? I have a set of data that I need to import, after loading data I don't have an option to use an existing transforming map but rather I'm asked to create a new map?

Is going to the existing transform map and changing the source table to the new import table is the right way to do it? Also, is there any rollback option once the transform had been performed.

Thanks

[jose_valle]

Hi Darshak,

You can update the import set table on the transform map, but you will still need to make sure that all of the source fields exists and are correct for each of your field map entries. You will also need to make sure that your scripts will still work if you are accessing any values from the source table. Might be just as easy to create a new transform map.

No, there is no rollback once the transform has completed.

Hope this helps.

[Rama Chandra D]

Yes, I have ensured that the field names exist in the import table. The existing transform map serves the purpose and hence, I prefer to use the same. So let me reiterate, updating the source table in existing transform map is enough to do the job, right?

Thank you.

Darshak

[jose_valle]

Hi Darshak,

I took a closer look and it looks like you will need to update the individual transform entries as well to point to the correct source table and field name since they will still be using the original source table name.

Thanks,

[Rama Chandra D]

Can I use multiple existing transform maps on new import table?