Query to create Repository User in Oracle
–Create a new tablespace: DROP TABLESPACE infa_repo_dev_ts INCLUDING CONTENTS; CREATE TABLESPACE infa_repo_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF; –Create the infa_repo_dev database user: DROP USER infa_repo_dev CASCADE; CREATE USER infa_repo_dev IDENTIFIED BY DB105you DEFAULT TABLESPACE infa_repo_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 […]
Query to create Domain User in Oracle
DROP TABLESPACE domain_dev_ts INCLUDING CONTENTS; CREATE TABLESPACE domain_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF; DROP USER domain_dev CASCADE; CREATE USER domain_dev IDENTIFIED BY DB105you DEFAULT TABLESPACE domain_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA […]
Informatica Powercenter 10.5 Upgrade Paths
https://docs.informatica.com/data-integration/powercenter/10-5/upgrading-from-version-10-2–10-5-/upgrade-overview/upgrade-paths.html
Linux User Creation With SSHKeypairs on AWS
In order create user account linux server with ssh keypair for login server with putty tool. Follow the below steps: Step 1: Login to Linux server where you want to create user account. Step 2: create user accouunt by using below command useradd -m -s /bin/bash Step 3: To check whether user account […]
Informatica Upgrade Planner on AWS
Query to check owner of each table in Redshift
Query to check owner of each table in Redshift SELECT n.nspname AS schema_name, pg_get_userbyid(c.relowner) AS table_owner, c.relname AS table_name, CASE WHEN c.relkind = ‘v’ THEN ‘view’ ELSE ‘table’ END AS table_type, d.description […]
Data Quality Elements (DQ Mapplets within PowerCenter)
SELECT OPB_SUBJECT.SUBJ_NAME AS PROJ, OPB_MAPPING.MAPPING_NAME AS MAPPING, OPB_WIDGET_INST.INSTANCE_NAME AS TRANSFORMATION, OPB_WIDGET.LAST_SAVED AS LAST_SAVED FROM OPB_WIDGET_INST INNER JOIN OPB_MAPPING ON OPB_WIDGET_INST.MAPPING_ID = OPB_MAPPING.MAPPING_ID INNER JOIN OPB_SUBJECT ON OPB_MAPPING.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID INNER JOIN OPB_WIDGET ON OPB_WIDGET_INST.WIDGET_ID = OPB_WIDGET.WIDGET_ID WHERE OPB_WIDGET.TEMPLATE_ID IN (SELECT PLG_ID FROM OPB_MMD_CATALOG […]
List Metadata Exchange Connections
SELECT REPOSITORY_ID, REPOSITORY_NAME, REPO_TYPE_NAME, IMW_REPOSITORY.DELETED_FLAG, EFF_FROM_DT, EFF_TO_DT FROM IMW_REPOSITORY, IMW_REPO_TYPE WHERE IMW_REPOSITORY.REPO_TYPE_UID = IMW_REPO_TYPE.REPO_TYPE_UID AND IMW_REPOSITORY.DELETED_FLAG = ‘N’ AND REPOSITORY_ID (‘IMM_MASTER_REPOSITORY’) ORDER BY REPOSITORY_UID
List Data Quality Mappings
Execute the following query in your Model Repositories (“MRSRepository”) Schema. SELECT PRD_ATTR_VALUE, PRR_TYPENAME FROM PR_RESOURCE, PR_ATTRIBUTE WHERE PR_RESOURCE.PRR_ID = PR_ATTRIBUTE.PRA_RESOURCE AND PR_ATTRIBUTE.PRD_ATTR_NAME = ‘REPO.SERVICE_PROP.UTC_CREATION_TIME_ATTR’ AND PR_RESOURCE.PRR_TYPENAME LIKE ‘%TokenStandardiserTxImpl’ OR PR_RESOURCE.PRR_TYPENAME LIKE ‘%AssociationTxImpl’ OR PR_RESOURCE.PRR_TYPENAME LIKE ‘%AvTxImpl’ OR PR_RESOURCE.PRR_TYPENAME LIKE ‘%CaseConverterTxImpl’ OR PR_RESOURCE.PRR_TYPENAME LIKE ‘%ClassifierTxImpl’ OR PR_RESOURCE.PRR_TYPENAME LIKE ‘%ConsolidationTxImpl’ OR […]
01. What is Cloud Computing?
What is Cloud Computing? Cloud computing is the on-demand delivery of compute power, database storage, applications, and other IT resources through a cloud services platform via the Internet with pay-as-you-go pricing. NOTE: Please refer to AWS portal for detailed information on all below topics.