ETL relationship mapping

[RupaliJ]

We are using ETL to import the data into CMDB TNI tables, also configuring the relationships with other tables as parent and child based on client provided information.

For some of the given records relationship is not happening due to insufficient data. So, the requirement is to restrict the data to insert where relationship is not building. 

Please suggest on this.

[Vishnu-K]

Hi @RupaliJ ,

You can achieve this by following way:

1. Let's say you have a field which decides the relationship will work or not .

2. For example if you are getting a sysid and populating them , then you can keep that field filter to a field which is the mandatory field.

3.Then your case is handled which is not inserting data when there is relation can be built.

If this answers your question, please mark it as helpful and accept the solution for better community visibility.

Thanks,

Vishnu