Thursday, June 10, 2021

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 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON infa_repo_dev_ts;


--Grant necessary privileges and roles to your infa_repo_dev database user:

GRANT CONNECT, RESOURCE TO infa_repo_dev;

GRANT CREATE TABLE TO infa_repo_dev;

GRANT CREATE VIEW TO infa_repo_dev;

GRANT CREATE SEQUENCE TO infa_repo_dev;

GRANT CREATE SESSION TO infa_repo_dev;

GRANT CREATE SYNONYM TO infa_repo_dev;

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 UNLIMITED ON domain_dev_ts;


GRANT CONNECT, RESOURCE TO domain_dev;

GRANT CREATE TABLE TO domain_dev;

GRANT CREATE VIEW TO domain_dev;

GRANT CREATE SEQUENCE TO domain_dev;

GRANT CREATE SESSION TO domain_dev;

GRANT CREATE SYNONYM TO domain_dev;

Wednesday, June 9, 2021

Informatica Powercenter 10.5 Upgrade Paths

 


Product

Versions

PowerCenter

You can upgrade to version 10.5 from the following versions including any hotfix and service pack:

·         10.1.1

·         10.2

·         10.4

·         10.4.1

Informatica Data Quality

You can upgrade to version 10.5 from the following versions including any hotfix and service pack:

·         10.1.1

·         10.2

·         10.4

·         10.4.1

Data Engineering Integration

Data Engineering Quality

You can upgrade to version 10.5 from the following versions including any hotfix and service pack:

·         10.1.1

·         10.2

·         10.2.1

·         10.2.2

·         10.4

·         10.4.1

If Data Engineering is in the same domain as any other product supported by the Informatica installer, verify that all products are upgraded to the same supported upgrade version before you upgrade to 10.5.

Data Engineering Streaming

You can upgrade to version 10.5 from the following versions including any hotfix and service pack:

·         10.2.2

·         10.4

·         10.4.1

Data Privacy Management

You can upgrade to version 10.5 from the following versions including any service packs:

·         10.4

·         10.4.1

If Data Engineering, Enterprise Data Catalog, 

Data Privacy Management

and are in the same domain of a version earlier than 10.4, upgrade them all to version 10.4 before you upgrade to 10.5.

Enterprise Data Catalog

You can upgrade to version 10.5 from the following versions including any service packs:

·         10.4

·         10.4.1

If Enterprise Data Catalog and Data Engineering are in the same domain of a version earlier than 10.4, upgrade them both to version 10.4 or 10.4.1 before you upgrade to 10.5.

Enterprise Data Preparation

You can upgrade to version 10.5 from the following versions including any service packs:

·         10.4

·         10.4.1

If Data Engineering, Enterprise Data Catalog, and Enterprise Data Preparation are in the same domain of a version earlier than 10.4, upgrade them all to version 10.4 or 10.4.1 before you upgrade to 10.5.

Test Data Management

You can upgrade to version 10.5 from the following versions:

·         10.2.0 Hotfix 2

·         10.4 and all service packs

·         10.4.1 and all service packs


https://docs.informatica.com/data-integration/powercenter/10-5/upgrading-from-version-10-2--10-5-/upgrade-overview/upgrade-paths.html