Semantic Groups in DTP

[Former Member]

Hi All,

In this blog, I am trying to explain the use of semantic groups option in DTP. You will get this option in extraction tab of DTP. Below is the screenshot showing the same.

Basically semantic groups are used for error handling. Let's take an example.

Suppose I have a DSO with a record

EmpID  Location  Salary

101      PUN         40000

Now I am running another load to DSO

It is as follows:

EmpID  Location  Salary

101      PUN         50000

101      PUN         60000

Salary 40000 is changed to 50000 and then to 60000.

When I run the  DTP, suppose if the first record (101 PUN 50000) has an error it won't get loaded to the DSO, it would go to error stack, the next record with salary 60000 will go to the DSO and overwrite salary 40000. After correcting the error in error stack when I run the error DTP the record with salary 50000 will go and overwrite the previous record. So finally the record in the DSO will have salary 50000 and not 60000 which is incorrect.

Here comes the use of semantic group.

We select the key for grouping as you can see in the screenshot. All the records are now grouped according to this key.

If any error comes system takes further records which have same key field combination to error stack and after correcting the erroneous record all the records will get loaded to the DSO in that order. Thus, we get correct data.