Ravisankar.P.R

ELT Process ETL process is Express Load and Transfer. There is ETL which is Express Transfer and Load. This process is used to load data in the form of excel files or csv files mainly which are converted to table data using python scripts and then transform the data so as to perform some calculations on this data and retrieve the data to get meaningful insights or reports.

select user_id , count(user_id) from t_gsa_session_details_ratepro where login_time between '2025-01-01 00:00:00.000' and '2025-07-03 00:00:00.000' group by user_id having count(user_id)>=1 ;

Rally is a project management tool, specifically designed for Agile development, that helps teams track and manage their work across iterations and releases. It supports various Agile methodologies like Scrum, Lean, Kanban, and Scaled Agile Framework (SAFe), offering features like team planning, release tracking, and work views.

EASY DEPLOYMENT IN TOMCAT SERVER TAKE A BACKUP OF WAR FILE FROM PROD TO Desktop 1) sudo -i 2) systemctl stop tomcat_ratepro_app [ CHECK APPLICATION IS WORKIKNG] 3) cp -r /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0.war /home/gehc-cloud/Bkp/Prod_bkp_on_18Jan2025/ 4) cp -r /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 /home/gehc-cloud/Bkp/Prod_bkp_on_18Jan2025/ 3) rm -rf /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0.war;rm -rf /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 4) cp -r /home/gehc-cloud/GSA_To_Deploy_Files/RatePro-App-1.0.0.war /apps/ratepro/ratepro_app/webapps 5) chmod -R 777 /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0.war 6) systemctl start tomcat_ratepro_app [RatePro-App-1.0.0 FOLDER WILL BE CREATED] 7) tail -100f /apps/ratepro/ratepro_app/logs/catalina.out 8) \cp -r /home/gehc-cloud/GSA_To_Deploy_Files/dist/* /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 9) chmod -R 777 /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 ...

  Like the King commands... When thinking of commands in Linux, I am reminded of the old stories of kings and military leaders who issue orders to their subordinates, expecting them to be executed promptly and accurately. Just like the king's command, a Linux command must be carried out in a timely and precise manner to achieve the desired result. Similarly, when we use commands to instruct our computers, we are telling them to perform specific tasks quickly and accurately, with results we are awaiting. Commands like "ls" or "ps -f | grep '.txt'" are common examples we use daily. These commands simplify our lives, and just like the orders of a king, they are often crucial and lawful. I’m referring to the way we use Linux commands to execute tasks and view their results. Linux is a powerful and wonderful operating system that presents its results in a structured and informative manner. However, mastering these commands and understanding their outputs requ...

Renew SSL certificates in Tomcat  Step 1: Prepare your SSL certificate files You have to import all the necessary certificate files separately in the correct order. Run the commands below for each certificate type: Root Certificate : keytool -import -alias root -keystore example.jks -trustcacerts -file root.crt Intermediate Certificate : keytool -import -alias intermediate -keystore example.jks -trustcacerts -file intermediate.crt Step 2: Edit the Tomcat configuration file After the import, your next step is to edit the Tomcat configuration file. By default, it’s called  server.xml  and resides in the  Home_Directory/conf  folder. Locate the configuration file.You should see a few lines of code similar to the example below: <Connector port="443" protocol="HTTP/1.1" SSLEnabled="true" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keystoreFile= "/your_path/yourkeystore....

Download Oracle Instant Client tools :instantclient-tools-windows.x64-21.12.0.0.0dbru  SQL*Loader Features SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the data file. You can use SQL*Loader to do the following: Load data across a network if your data files are on a different system than the database. Load data from multiple data files during the same load session. Load data into multiple tables during the same load session. Specify the character set of the data. Selectively load data (you can load records based on the records' values). Manipulate the data before loading it, using SQL functions. Generate unique sequential key values in specified columns. Use the operating system's file system to access the data files. Load data from disk, tape, or named pipe. Generate sophisticated error reports, which greatly aid troubleshooting. Load arbitrarily comple...

                                                                            DEVOPS

 Proof Of Concept or POC POC or Proof Of Concept is done for the following reasons : 1) Less Waste Of Resources: POC's prevent you from dumping resources into projects that are unlikely to succeed. 2) More Funding from Clients : Investors are more likely to fund a project that has been proven viable. 3) Better Planning : A POC will make you think about project logistics before you even get started. 4) Fewer Road Blocks : Challenges to viability will stick out to you when writing a POC and can inform project direction Some snippets on POC's  1) POC  helps us to determine whether an idea is feasible before developing it in to a product. 2) Prototype : Prototype is a model of your product that can be tested to provide an idea of how it will function  3) Minimum viable product : An MVP is refined version of your prototype that's tested to identify minor issues and create the final product.

  Commands For Prod : ==================== keytool -import -alias href-hydro.cloud.ren.apps.ge.com_root -keystore "C:\Program Files\Java\jdk1.8.0_291\jre\lib\security\cacerts" -file "D:\keys\certs\href-hydro.cloud.ren.apps.ge.com_intermediate_cert.crt" keytool -import -alias href-hydro.cloud.ren.apps.ge.com -keystore "C:\Program Files\Java\jdk1.8.0_291\jre\lib\security\cacerts" -file "D:\keys\certs\href-hydro.cloud.ren.apps.ge.com.crt" keytool -importcert -trustcacerts -alias repo -file "D:\cert\staging-href.re.ge.com.cer" -keystore "C:\Program Files\Java\jdk1.8.0_291\jre\lib\security\cacerts" -storepass changeit keytool -importcert -trustcacerts -alias repo -file "D:\cert\staging-href.re.ge.com.cer" -keystore "C:\Program Files\Java\jdk1.8.0_291\jre\lib\security\cacerts" -storepass changeit keytool...

                                        Git Commands Git clone command This command is used to make a copy of a repository from an existing URL. If I want a local copy of my repository from GitHub, this command allows creating a local copy of that repository on your local directory from the repository URL. Syntax $ git clone URL   Git add command This command is used to add one or more files to staging (Index) area. Syntax To add one file $ git add Filename   To add more than one file   $ git add*     Git commit command Commit command is used in two scenarios. They are as follows. Git commit -m This command changes the head. It records or snapshots the file permanently in the version history with a message. Syntax $ git commit -m " Commit Message"     ...

  EXCEL Issue : In excel, date field is coming as numeric value when changing in to text format. For this do the below steps: 1) change the date column field in to text format. 2) Now it becomes numeric values. 3) Delete the field data (numeric values) 4) Copy the actual required date format (2009-02-25) in to notepad 5) Copy it again and past it in the excel where numeric fields were deleted. 6) Now date will be in text format and un editable.

  Selenium Automation Selenium  is a free (open-source) automated testing framework used to validate web applications across different browsers and platforms. You can use multiple programming languages like Java, C#, Python, etc. to create Selenium Test Scripts. Testing done using the Selenium testing tool is usually referred to as  Selenium Testing .   Selenium Tool Suite Selenium Software is not just a single tool but a suite of software, each piece catering to different Selenium QA testing needs of an organization. Here is the list of tools Selenium Integrated Development Environment (IDE) Selenium Remote Control (RC) WebDriver Selenium Grid Who developed Selenium? Since Selenium is a collection of different tools, it also had different developers. Below are the key persons who made notable contributions to the Selenium Project Primarily, Selenium was  created by Jason Huggins in 2004 . An engineer at ThoughtWorks, he w...