1. What is AS-IS and To-Be Process?
AS-IS, commonly referred to as “present state,” describes how a process is being carried out at the moment, including all of the steps required and the tools and technologies utilised to finish the process.
TO-BE, also referred to as the “future state,” describes how a process will be carried out once it has been enhanced or rebuilt.
To find potential for process improvement and automation using RPA, AS-IS and To-Be processes are frequently employed in the context of robotic process automation (RPA). These procedures compare the existing state of a process with the planned future state. Usually, the objective is to automate as much of the process as you can in order to increase effectiveness, decrease errors, and cut expenses.
You would normally begin by examining the current AS-IS process to comprehend how it functions and pinpoint places where automation could be useful before developing a TO-BE process. The To-Be process would next be designed, taking into consideration the RPA software’s capabilities as well as any additional limitations or requirements. The To-Be process would then be put into action, tested, and made sure it was functioning as intended.
Flow diagrams or flowcharts are generally prepared by using tools like Microsoft Visio by Business Analysts covering all the steps in the process.
2. What do you mean by PDD and SDD?
PDD stands for Process Design Document. A PDD contains the details about the Process like steps that are executed in the AS-IS process and the To-Be process.
As a best practice in the IT industry, a PDD has to be signed off by the Business team to start a process in order to avoid challenges in the future.
SDD stands for Solution Design document which contains the details about the design that will be used to automate the process.
A few companies call it a Development Specification Document which majorly covers the details of the Workflows implemented in the code.
3. Please explain something regarding Project documentation work?
Project documentation in Robotic Process Automation (RPA) is the group of records and materials used to organize, monitor, and discuss an RPA project. In order to ensure that everyone working on the project has a clear grasp of its scope, objectives, and progress, project documentation is a crucial component of the RPA development process.
Depending on the individual requirements of the project, a wide variety of documents may be included in an RPA project documentation package. Typical RPA project documents include the following:
The business Analyst will take of the “Business Requirements Document (BRD)” or PDD
SDD and TDD will be handled by the technical team.
It is a good practice to have a step-by-step detailed document (i.e Key Stroke Document) of the manual process along with screenshots for best results.
4. What is a DataTable? How can we get the number of rows and columns in a DataTable?
The DataTable in C# is similar to the Tables in SQL. That means the DataTable is also going to represent the relational data in tabular form i.e. rows and columns and this data is going to be stored in memory which can be used later for any manipulations.
Let’s assume that my_DT is the DataTable variable :
To get the number of rows in a DataTable “my_DT”, we can use the following code snippet :
To get the number of columns in a DataTable ”my_DT”, we can use the following code snippet :
5. How do you get the current date, add/subtract days from the current date, and add/subtract hours from the current date?
- To fetch the Current Date, please use the below code snippet :
DateTime.Now or simply we can use Now
- To Add/ Subtract days from the current date, please use the below code snippet:
- Add/ Subtract hours from the current date, please use the below code snippet:
Similarly, it can be done for years and months.
6. How to get all the files from a given folder?
We can use the below code to get the list of files in a given folder…
The above will give you an array of strings as output which, can contain all the file names which are available in that folder.
And if we want to display those on the screen, we can use the “For Each” activity and a message box along it.
7 . What is the use of Cint?
CInt is one of the very frequently used Data Conversion function
It has the ability to convert from a variety of types (including String, Double, and others) to Integer(Int32) types. The original data for instance, if it was double or it was a string like “1000,” an Int32 numeric value 1000 would be produced.
Additional Resource: Click here
8. Can you please convert the below date which is in String Type to DateTime Type please?
Input: “22-01-2023” (String Type)
The above code does the required work.
Output: 22-01-2023 (DateTime Type)
Though the output remains the same visually, this output will be used for comparisons.
Note: You don’t have to mug up the code, you can just remember that the ParseExact function of the DateTime class is used in this kind of situation 🙂
9. What are the benefits of ReFramework ?
- Reusability: It works with any kind of process and is independent of data source (i.e QueueItems, Excel files, Database, PDF, emails, and JSON response).
- Exception Mechanism & Retry Facility: It helps us to capture the exception that occurred in transaction processing and allows us to re-execute the transaction.
- Logging: It Generates logs at every transaction level, which can help us in auditing the process
- Config File: It enables us to maintain our frequently changing values i.e. URLs, File paths e.t.c in a single place, that the process will actually use while executing.
10. If in a project, you have a lot of unused variables and arguments, Is it possible to remove them all at once? If YES, then how?
In UiPath Studio, we have an option called, Remove unused, using which we can remove any of the displayed components like variables, arguments, dependencies, etc by just simply clicking on the required selection