can i have 2 transform maps in one data source?

[manmathpanda]

Hi Developers,

My requirement is as below:

i want to fetch the inactive/ locked out employees in another table ,so that i can use these employee details in my shift allowance.

Below is the screen shot which my org is using. Through this i can able to find out active user details. But i want to fetch all locked out employees in different table?

How can i achive this?

1> is this possible to create one more transfer map within this data soucre?

2> if i will create one more data source with same name but name i took as : Inactive NTL SAP Integration and table name as vw_inactive_emp_table but while saving it, it is not creating one more data source?

Could anyone please suggest me what to do in this case?

How can i find inactive/locked out employee details and it should be schedule basis?

[Snehal Pawar]

Hi,

It is possible to have multiple maps for a data source, but you can only have one source table per data source.

Thanks,

Snehal.

[manmathpanda]

Hi Snehal,

yes i am using one staging table only . 

In transform map:

source table is : ntl sap employee staging table

target table is: u_ntl_sap_employee_master 

which is transfering active user data

Now if i will create one  more transform map and i will take same staging table but different target table to fetch the data. is this ok?

If i will take 2 transform maps , is there will be any conflict while transfering data?

Regards,

Manmath 

[Snehal Pawar]

Hi,

You can use two different target table for same.

You can run two transform maps in an order suited to transform the data to two different tables. Your staging table that is your source table will hold the data from data source. Then you can apply two transform and use two different target tables. You would have to create a field map to transform the specific columns for that particular table.

So your source table remains the same and target table differs.

Thanks,

Snehal.

[Vishal Khandve]

Hello,

you can use multiple transform map in one data source.

it run from lowest to highest order.

below link will help you.

https://community.servicenow.com/community?id=community_question&sys_id=59193317db239b841cd8a345ca96...

Thanks,

Vishal