Handewadi, Pune, India - 411028.
Verified 1
Details verified of Akshay Godhamgaonkar✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
Marathi Mother Tongue (Native)
Hindi Proficient
English Proficient
MIT School of Business, Pune 2012
Master of Business Administration (M.B.A.)
SAP 2022
SAP S/4 HANA
SAP 2022
SAP ECC FI
Handewadi, Pune, India - 411028
ID Verified
Education Verified
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in SAP Training
11
Provides training for the following SAP FM modules
SAP FICO, SAP Simple Finance (SAP S/4 HANA Finance), SAP GST
Provides training for
Procurement Management Products, Financial management products
Provides training for the following SAP Procurement Management modules
SAP MM
5 out of 5 1 review
Ishan Sharma
SAP
"Very good. Would recommend 10/10 Very nice teacher and knows all his basics. Thorough knowledge in SAP. "
Reply by Akshay
Thank you Ishan!
1. Which classes do you teach?
I teach SAP Class.
2. Do you provide a demo class?
Yes, I provide a free demo class.
3. How many years of experience do you have?
I have been teaching for 11 years.
Answered on 09 Jan Learn IT Courses/SAP
In SAP BODS, you can replicate each record 4 times using the following approach:
Use a Query transform: Add a Query transform in your data flow. This transform allows you to create custom SQL expressions to manipulate your data.
Use a UNION ALL statement: Within the Query transform, write a SQL expression that includes a UNION ALL statement to combine the original data with itself multiple times. For example, if your original table is named "source_table", the SQL expression might look like this:
SELECT * FROM source_table UNION ALL SELECT * FROM source_table UNION ALL SELECT * FROM source_table UNION ALL SELECT * FROM source_table
This SQL expression replicates each record from the "source_table" four times.
Map the output: Map the output of the Query transform to your target table or file.
Validate and execute the job: Validate the data flow to ensure that each record is replicated 4 times as expected. Then, execute the job to perform the data replication.
By following these steps and using the Query transform with a UNION ALL statement, you can replicate each record 4 times in SAP BODS.
Answered on 09 Jan Learn IT Courses/SAP
Hi Latha,
The XML Parser Error in SAP BODS V4.2SP02 typically occurs when there is an issue with parsing XML data within the SAP BusinessObjects Data Services (BODS) environment.
This error can be caused by various issues such as incorrect XML syntax, invalid characters, or mismatches between the XML structure and the parsing logic.
To troubleshoot this error, you can start by checking the XML source data for any syntax errors or inconsistencies. Additionally, review the XML parsing logic and ensure that it is compatible with the structure of the XML data being processed.
If you have specific error messages or details about the XML Parser Error, providing more information would allow for a more targeted and accurate resolution.
Regards,
Akshay
Answered on 09 Jan Learn IT Courses/SAP
Yes, it is possible to migrate BODs jobs into Informatica ETL tool. However, there are some differences between these two tools. For ex, in BODS, there is a concept called Template tables which will automatically useful to create source schema. But in Informatica, we need to manually create source schema every time12. Similarly, in BODS, there are SQL scripts which we can use to achieve business logic before or after a job is finished. In contrast, in Informatica, we need to manually export jobs.
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in SAP Training
11
Provides training for the following SAP FM modules
SAP FICO, SAP Simple Finance (SAP S/4 HANA Finance), SAP GST
Provides training for
Procurement Management Products, Financial management products
Provides training for the following SAP Procurement Management modules
SAP MM
5 out of 5 1 review
Ishan Sharma
SAP
"Very good. Would recommend 10/10 Very nice teacher and knows all his basics. Thorough knowledge in SAP. "
Reply by Akshay
Thank you Ishan!
Answered on 09 Jan Learn IT Courses/SAP
In SAP BODS, you can replicate each record 4 times using the following approach:
Use a Query transform: Add a Query transform in your data flow. This transform allows you to create custom SQL expressions to manipulate your data.
Use a UNION ALL statement: Within the Query transform, write a SQL expression that includes a UNION ALL statement to combine the original data with itself multiple times. For example, if your original table is named "source_table", the SQL expression might look like this:
SELECT * FROM source_table UNION ALL SELECT * FROM source_table UNION ALL SELECT * FROM source_table UNION ALL SELECT * FROM source_table
This SQL expression replicates each record from the "source_table" four times.
Map the output: Map the output of the Query transform to your target table or file.
Validate and execute the job: Validate the data flow to ensure that each record is replicated 4 times as expected. Then, execute the job to perform the data replication.
By following these steps and using the Query transform with a UNION ALL statement, you can replicate each record 4 times in SAP BODS.
Answered on 09 Jan Learn IT Courses/SAP
Hi Latha,
The XML Parser Error in SAP BODS V4.2SP02 typically occurs when there is an issue with parsing XML data within the SAP BusinessObjects Data Services (BODS) environment.
This error can be caused by various issues such as incorrect XML syntax, invalid characters, or mismatches between the XML structure and the parsing logic.
To troubleshoot this error, you can start by checking the XML source data for any syntax errors or inconsistencies. Additionally, review the XML parsing logic and ensure that it is compatible with the structure of the XML data being processed.
If you have specific error messages or details about the XML Parser Error, providing more information would allow for a more targeted and accurate resolution.
Regards,
Akshay
Answered on 09 Jan Learn IT Courses/SAP
Yes, it is possible to migrate BODs jobs into Informatica ETL tool. However, there are some differences between these two tools. For ex, in BODS, there is a concept called Template tables which will automatically useful to create source schema. But in Informatica, we need to manually create source schema every time12. Similarly, in BODS, there are SQL scripts which we can use to achieve business logic before or after a job is finished. In contrast, in Informatica, we need to manually export jobs.
Share this Profile
Also have a look at
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.