Skip to Content
Author's profile photo Former Member

Semantic Groups in DTP

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.

Capture.PNG

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.

Assigned Tags

      39 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice blog

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Puja...

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Simple and nice..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Suman.

      Author's profile photo Rishabh Awasthi
      Rishabh Awasthi

      Good one..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Rishabh...

      Author's profile photo Shanthi Bhaskar
      Shanthi Bhaskar

      Nice One...I used this option with good affect in BI 7.0.

      for instance in my Start or End routine I am getting PO line item data, I have a scenario where I need to arrive at sequence number for line items corresponding to a PO. If data is less than 50k then I would normally use sort command for getting PO's in an order, but when one PO is getting loaded in multiple packets the above logic doesn't work. I this case we can use semantic grouping option on PO. then system doesn't split the PO into multiple packets. It will always load into the single packet.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Yes Bhaskar...I also faced a similar situation and this option helped me...That's why thought of sharing it....

      Author's profile photo Former Member
      Former Member

      Well explained Jatin.

      Simple , informative and to the point.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Priyanka...

      Author's profile photo CH Raman
      CH Raman

      Nicely explained with example and easy to understand.

      Really good one.

      Thanks

      Raman

      Author's profile photo Former Member
      Former Member

      Nice article. but u can also write semantic keys and difference between semantic groups and semantic keys

      Author's profile photo Former Member
      Former Member

      Good one Jatin ..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Nethaji...

      Author's profile photo Former Member
      Former Member

      Nice One Jatin...

      🙂 Purushotham

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks you all...

      Author's profile photo Former Member
      Former Member

      Nice and Very useful information Jatin......

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Prasad !!!

      Author's profile photo Former Member
      Former Member

      Explained beautifully! Thanks for sharing.

      Regards,

      Prasad

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Prasad !!!!

      Author's profile photo Former Member
      Former Member

      Nicely explained , thanks for sharing....!

      BR

      Aakash G

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Aakash !!!

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Nice and simple.

      Thanks

      Kamal

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Kamal...

      Author's profile photo Former Member
      Former Member

      Good One Jatin. Hope Post document along with semantic key.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Karthick for your appreciation and suggestions !!!

      Author's profile photo Vijay Mohan Velpula
      Vijay Mohan Velpula

      Crisp and Clear.

      Thanks Jatin.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Vijay !!!

      Author's profile photo Former Member
      Former Member

      Good explanation with example. thanks

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Raghav...

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice document.......nicely explained...... 🙂

      Regards,

      SM

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Nice blog....informative.

      Regards,

      Krishna Chaitanya.

      Author's profile photo Ravi Chandra
      Ravi Chandra

      Simple and Good ....

      Thanx for sharing...

      Author's profile photo Matthew Billingham
      Matthew Billingham

      Basically semantic groups are used for error handling.

      I rarely use them for error handling. I use them to ensure that I don't get the keys I'm interested split across packages.

      Author's profile photo Vinoth Vasudevan
      Vinoth Vasudevan

      Awesome example Jatin. Thank You for sharing.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you all !!!

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Simple but useful information jatin...keep it up 🙂

      Author's profile photo Pradip Nikam
      Pradip Nikam

      Very Good Document

      Author's profile photo Former Member
      Former Member

      Very Nice Document