How to view the Operation codes or opcodes in Data Services?

dataservices job design
1

I know that data services maintains operation codes or opcodes to flag the status of each row of every data set involved in data flows. I want to see what is the status of each row. How can I do that ?

This is what I expect to see when I “look at” an employee table that contains Employee ID,Salary and Address -

Employee ID,Salary,Address,(OpCode)
1, 10,abc street, UPDATE
2, 20, dfg avenue, INSERT

etc.

Please show me a simple way to do this.

Thanks.

sapmonkey (BOB member since 2013-09-17)

2

I would not say it is a simple way, but one way would be:


          - MAP_N - QRY_N - \
        /                    \
       / -  MAP_U - QRY_U -   \
QRY -                          - MERGE - TABLE
       \ -  MAP_I - QRY_I -   /
        \                    /
          - MAP_D - QRY_D - /

In each of the maps you map each operation (Normal, Update, Insert, Delete) to itself and all others to discard. In each query you add a column (opcode) and set it to the appropriate value. Merge and output.

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)

3

Thanks. Can you post some more steps for this and perhaps some screenshots (data flow elements, settings inside your MAP and query transform) ? I am new to this tool and ETL and I just finished reading the basic tutorial included with SAP DS 4.0. So, its a little difficult for me to understand short instructions. I think if I can get the steps to make the branch part of your diagram, then I can do the rest myself. Hopefully, it should not be too difficult.

This question came up randomly in my mind and I was wondering if the values of Opcodes can be useful in any real world project or is it just an academic exercise.

Thanks

sapmonkey (BOB member since 2013-09-17)

4

Not to be rude, but give it a shot and let us know if you have problems. You will not learn by being spoon fed, you learn by making mistakes and figuring them out. Happy to help if you run into a specific problem. After the tutorial, the BODS10 class is an excellent way to learn DS.

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)

5

Okay, I will try and get back. Btw, what is this BODS 10 class ? I have never heard of it.

sapmonkey (BOB member since 2013-09-17)

6

https://training.sap.com/v2/course/bods10-sap-businessobjects-data-services-40-classroom-096-us-en/

eepjr24 :us: (BOB member since 2005-09-16)

7

It’s been quite a while since I used debug but I thought you could see the op codes in debug.

eganjp :us: (BOB member since 2007-09-12)

8

Hi,

Execute the job in debug mode for viewing the opcodes in DS.

DbUoRdAsI :india: (BOB member since 2012-05-08)