Hi, Thanks a lot for sharing this video. I am from Microsoft background and new to SAP. This video is very clear and your explanation is very understanding.
@2:28 if you are setting the Value of your variable to a Constant how this value will change for the next run? Thanks for the tutorial though it helped me get through most of it but stuck at this point. Thanks.
Hi Saurav, Could you please explain how you introduced the surrogate key in this job. I have two keys(id,sq) which make up a composite key to identify each row uniquely in my source table. How would I use table comparison transform in this case. Ajay
The Link you mentioned very suspicious to system , it is detecting as a virus . I tried to open but not able to open it. Please share the data mentioned in this example .
hi, Id like to know how the bods updates the data without using map operation transformation.I believe we must add an map operation transformation after comparing the data.
Akash: I tried recreating this mapping. When i was trying to create a global variable the interface does not provide me an option to enter a value. Why is that so? I only see "Name:" and "Data type:" options available. What am i doing wrong?
From watching this video not able to create new one. Customer Key column is not able to create. Who ever created this video it wrong. Please update the video. This is wrong video.
+HARISH PUTHRAN You should have customer key as primary key column created in database, use key generation transform to enter values eg. row no so that you have new unique values instead of old primary or composite key. So comparison will be based on new primary key.
Very effective; Very simple; and one concept per video is a very efficient approach.
Hi, Thanks a lot for sharing this video. I am from Microsoft background and new to SAP. This video is very clear and your explanation is very understanding.
Very nice brother .God bless you👍
@2:28 if you are setting the Value of your variable to a Constant how this value will change for the next run? Thanks for the tutorial though it helped me get through most of it but stuck at this point. Thanks.
Hi, i am following all your BODS Tutorials, its really cool. Can you provide any tutorial based on real-time project
hello you have mention that the customer id will auto increment by 1. Can you please explain How?
Hi Saurav,
Could you please explain how you introduced the surrogate key in this job.
I have two keys(id,sq) which make up a composite key to identify each row uniquely in my source table. How would I use table comparison transform in this case.
Ajay
The Link you mentioned very suspicious to system , it is detecting as a virus . I tried to open but not able to open it.
Please share the data mentioned in this example .
You need to be at the Job Workspace, the click on Variables and Parameters and create or edit Variables.
hi,
Id like to know how the bods updates the data without using map operation transformation.I believe we must add an map operation transformation after comparing the data.
Our target table has a Created Date and a Modified Date. For updates, we don't want the Created Date to be updated. How can this be accomplished?
Akash: I tried recreating this mapping. When i was trying to create a global variable the interface does not provide me an option to enter a value. Why is that so? I only see "Name:" and "Data type:" options available. What am i doing wrong?
From watching this video not able to create new one.
Customer Key column is not able to create.
Who ever created this video it wrong. Please update the video.
This is wrong video.
+HARISH PUTHRAN You should have customer key as primary key column created in database, use key generation transform to enter values eg. row no so that you have new unique values instead of old primary or composite key. So comparison will be based on new primary key.
Thanks done