Robust Transformation Map

[Sweenal]

Hello Everyone,

Please help me with below requirement:

I need to transform one excel sheet into two different target tables in which half data is of target1 table and another data for target2 table.So the usecase is if I have 5 fields in target1 and 5 fields in target2 .so one field  of target1 table should be referenced to another field of target2 table and should be populated by reference on another table in target table.

Example:

I want to import data in incident and incident_task tables, Also for each record generated in incident_task table the field incident should be populated with the corresponding incident number which was created.

How Can I achieve it please let me know.

--

Regards,

Sweenal 

[palanikumar]

Hi,

Create two transform map for the same data source but pointing to different tables. Now you can map data to appropriate tables.

Another option is, you can create transform map, the other one table can be updated using transform map scripts.

[Sweenal]

Hi,

But I need to do this via robust transform map.Can you help me with that.

--

Thanks,

Sweenal

[palanikumar]

Hi,

You can add multiple tables using Entities in ETL definition.

Refer this video for instructions

https://www.youtube.com/watch?v=d26ajptaRgQ