normal and insert opcode in Map Operation

[former_member196263]

Hi,

Can someone help me in understanding the difference between normal and insert opcodes of map operations?

Please provide an example for this.

Thanks.                            

[Former Member]

Hi,

Any normal records coming from the input will be treated as normal in output if MO has normal in output schema. Any new records coming from the input will be inserted if insert selected in the MO output.

Check this http://scn.sap.com/community/data-services/blog/2013/07/05/scd-type-implementation-in-bods

Arun

[former_member196263]

Thanks Arun.

Could you please explain the difference between Normal as Insert and Insert as Insert?

I always get confused with this.

Thanks.

[Former Member]

Hi,

Normal to insert and insert to insert is not generally used together in a single data flow, unless it is split and merged into a target table. Because both serves the function of inserting records.

For example - say you need to insert a flag 1 in a target table for every inserted records. Assume if you are using a query transform to do some date functions before loading to target then the flow will be like below -

src > qry > tc > mo (insert - normal)> qry > mo (normal - insert) > target

Here since query transform will convert any inserted records to normal, normal to insert is required in the second MO. Otherwise all the records will be treated as normal.

Say you want to discard all the normal records from the source and only need to insert new records in target then -

normal - discard

Insert - insert

Update - discard

Delete - discard

Hope this helps.

Arun

[former_member196263]

Thanks Arun,

I will try with the data and will let you know in case of any confusion.

Thanks,

Akhilesh

[former_member187605]

Records streaming into a dataflow always have a Normal opcode. The opcode can change implicitly (in Table_Comparison and History_Preserving transform) or explicitly (Map_Operation). By default, when a record arrives at a target table, a Normal opcode will result in an Insert operation, any other opcode will provoke an operation as of its name (insert, update, delete).