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

Comments

Post a Comment

Popular posts from this blog

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