Learning BI

When Domain database password is changed from the database side, it needs to be updated in the nodemeta.xml file to start the Informatica services successfully. To update the domain database password, do the following: Backup nodemata.xml from INFA_HOME/isp/config. Go to the INFA_HOME/isp/bin directory and run following command: infasetup.sh updategatewaynode -dp new password     (for UNIX)infasetup.bat updategatewaynode -dp new password    (for WINDOWS)        3. Start the Informatica services. After Informatica Services are started and Informatica Administrator is up, the password for the PowerCenter Repository Service can be updated by editing the database properties of the repository in Admin console.

How to take Informatica Repository Backup  and restore it. Informatica Repository backup can be taken in 2 ways Admin Console pmrep command Using Admin Console Login to admin console. Select Repository service Select Backup contents under Actions menu to take backup of repository contents. Provide repository service username, password. provide a name for the backup that will create a backup file with .rep extension. the backup will be generally stored to infa_shared backup folder. Using pmrep command pmrep connect -r <repository_name> -d <domain_name> -n <user_name> -x <password> pmrep backup -o <output_file_name> [-d <description>] [-f (overwrite existing output file)] [-b (skip workflow and session logs)]  [-j (skip deploy group history)] [-q (skip MX data)] [-v (skip task statistics)] Restore Backup: Using pmrep command To restore a repository backup, it is to be ensured that the repository database ...

Change Permissions in Numeric Code in Linux You may need to know how to change permissions in numeric code in Linux, so to do this you use numbers instead of “r”, “w”, or “x”. 0 = No Permission 1 = Execute 2 = Write 4 = Read Basically, you add up the numbers depending on the level of permission you want to give. example of changing permissions in numeric code in Linux Permission numbers are: 0 = --- 1 = --x 2 = -w- 3 = -wx 4 = r- 5 = r-x 6 = rw- 7 = rwx For example: chmod 777 foldername will give read, write, and execute permissions for everyone. chmod 700 foldername will give read, write, and execute permissions for the user only. chmod 327 foldername will give write and execute (3) permission for the user, w (2) for the group, and read, write, and execute for the users.

VI Editor In Unix or Linux Operating systems, we use VI editor to create scripts or make changes to configuration files or programs. Below commands might be useful for you at the initial stages. Procedure to create or edit file is as shown below. Open the terminal application in Linux or Unix Next, open a file or create a file in  vi, type: vi filename To save a file in  vi, press Esc key, type :w and hit Enter key One can save a file and quit  Vi by pressing Esc key, type :x or :wq! and hit Enter key. If you do not want to save any changes, first press Esc key. To exit Vi without saving changes press :q! followed by ENTER key Summary of vim/vi commands Command Description Press the  ESC  key Type  :q! Press the  ENTER  key Exit vim without saving changes i.e. discards any changes you made. Press the  ESC  key Type  :wq Press the  ENTER  key Save a file and exit. Press the  ESC  key T...

Crontab Cron is utility to schedule commands at specific time.Cron is generally used for running scheduled backups, monitoring disk space, deleting files (for example log files) periodically which are no longer required, running system maintenance tasks and a lot more. Format of Crontab: Minute(0-59) Hour(0-24) Day_of_month(1-31) Month(1-12) Day_of_week(0-6) Command_to_execute Commands to remember for Cron #Display contents of crontab $ crontab -l #edit cron jobs $ crontab -e #edit the crontab of a different user $ crontab -u <User> -e #To remove all cron jobs for the current user $ crontab -r Example: To run a cron job at every minute * * * * * <command-to-execute> To run cron job at every 5th minute */5 * * * * <command-to-execute> To run a cron job every hour at minute 30 30 * * * * <command-to-execute> To run a cron job every 2 hours 0 */2 * * * <command-to-execute> To run a cron job every day at 2 PM 0  14 * * ...