Posts

Showing posts from 2023

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