Cleansing Package | Lock IssueCauses :-System is idle for long time in Cleansing Package Read_Write modeWhen your Rule is updating large data then there is more chances of Package locking :-Eg:- 1. When adding Any Regular expression in ...
I am explaining with inconsistent Mobile Number data but you can use it for inconsistent Zip code also.
BASE_USER_DEFINED Transform:-
As we already discussed how to use User_Defined Transform in http://scn.sap.com/community/data-services/blog...
In my Previous post(http://scn.sap.com/community/data-services/blog/2013/01/31/how-to-use-userdefined-transform-in-sap-bodsbusiness-object-data-services) I explained How to use User_defined Transform.
Here I am going to explain the Code which i u...
In this article we are explaining How to use Base_UserDefined transform step by step with an example of Replacing Special characters from the
input field(Salary).
Base_UserDefined Transform
This transform provides an interface to do anythin...
First you have to run the Lookup initialize job .That will create the Lookup tables to db level.SAP RDS is not supporting SQL Anywhere directly , have to modify many things , so better to use another db for RDS or resolve issues one by one.~ Kamal
Thanks Amin for nice and informative blog.
I have few queries and will be great if you can help -
1. Do we get SAP Data Services as free with STE.
2. Is there any difference in Migration cockpit approach in different deployed solutions like on pre...
to_char(to_date(<field>, 'YYYY.MM.DD'), 'MM/DD/YYYY')1. First you have to convert char into date format and have to mention the source format in second parameter 'YYYY.MM.DD'2. After conevrting into date use to_char function to convert the same into ...
HI Nikhil,I hope you are following the below points ;-1. In 1st Dataflow Extract the ERP table data into SQL database2. Then apply join in coming dataflowsData is huge so either you have to go with very High Config system orFilter the data with where...