Posts

SQL Loader in ORACLE

Image
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...
Image
                                                                            DEVOPS

Why to do a POC (Proof Of Concept)

 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.

Command to import keys in Java Keystore

  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

Image
  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...