Informatica Powercenter Installation and Configuration tutorial 2

This video covers main products from Informatica (Powercenter, IDQ, MDM, Informatica Cloud) , installation and configuration of Informatica Powercenter 901 HF2 on Windows machine. Do check the installation related oracle scripts, download and install links in the below comment section.

[@Gogeeko]

You can also check out the playlist below for all videos in sequential order for Beginners complete Informatica Powercenter 9x ETL tutorial: Beginners Informatica Powercenter ETL tool overview tutorial

[@aameraftab1998]

Thanks for such nice video series. I cannot see the DDL scripts in comment section. Can you please provide them. Thanks

[@justice121188]

Very helpful tutorials. Thank you very much for putting this together for us.

[@Gogeeko]

Glad it was helpful!

[@sandeepnalam1]

Very Paitence , good Teaching......... Great Job

[@fasousa1000]

Thanks a lot for these posts about Powercenter

[@Gogeeko]

Here are the links, shown in the video: ++++++++++++++++++++++++++++++ Oracle DB and Client Download: www.oracle.com/technetwork/database/windows/downloads/index-093848.html Oracle Install video: Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7 Informatica download: ---------------------- edelivery.oracle.com/ Infa server install: -------------------- Informatica powercenter 901 installation in Windows 7 Part 1-Server installation) Infa Client Install: -------------------- Informatica powercenter 901 installation in Windows 7 Part 2-Client installation)

[@rohitluthra6884]

Awesome Video....really good information Thanks for posting

[@johnblue1830]

Hi GoGeeKo, can you please reload the the oracle script for Domain and Repository user? Thanks

[@ARUNKUMAR-vd5zv]

hi i installed informatica 9.0.1 after installing informatica i opened administrative page and logged with username and password as administrator. after logging the page is keep on loading nothing is coming can you help in this issue........i installed in w8

[@Gogeeko]

Here is the oracle script for Domain and Repository user: +++++++++++++++++++++++++++++++++++++++++++ -- ------------------------------------------------------------------------- -- Login as oracle -- ------------------------------------------------------------------------- set echo on set feedback on set linesize 140 set pagesize 50000 -- ------------------------------------------------------------------------- -- Fix ORA-12519 error with Oracle 10g XE version from default -- setting. Restart Database after creating all these users, tables, -- etc.. -- ------------------------------------------------------------------------- ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE; -- ------------------------------------------------------------------------- -- Fix ORACLE taking so much memory that nothing else can run -- ------------------------------------------------------------------------- ALTER SYSTEM SET memory_max_target = 1500M SCOPE=SPFILE; ALTER SYSTEM SET memory_target = 1408M; -- ------------------------------------------------------------------------- -- ------------------------------------------------------------------------- --Create seprate tablespace -- Increase Tablespce size based on your needs --For learning 200M is fine. CREATE SMALLFILE TABLESPACE DEV DATAFILE 'C:\app\user\oradata\orcl\tb_dev_01.DBF' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; -- ------------------------------------------------------------------------- -- Fix any Cursor issues -- ------------------------------------------------------------------------- ALTER SYSTEM SET OPEN_CURSORS = 1000 SCOPE=BOTH SID='DEV'; -- DROP ROLE INFA_OWNER; CREATE ROLE INFA_OWNER; GRANT CREATE SESSION, CREATE TABLE, CREATE ANY VIEW, CREATE PROCEDURE, CREATE SYNONYM, RESOURCE, CONNECT TO INFA_OWNER; -- ------------------------------------------------------------------------- -- This is the user account for creating the Informatica Domain -- Domain Service. -- ------------------------------------------------------------------------- -- DROP USER "DEV_DOM" CASCADE; CREATE USER "DEV_DOM" IDENTIFIED BY "admin" DEFAULT TABLESPACE DEV TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; GRANT INFA_OWNER TO "DEV_DOM"; GRANT "CONNECT" TO "DEV_DOM"; GRANT "RESOURCE" TO "DEV_DOM"; GRANT CREATE ANY VIEW TO "DEV_DOM"; -- --------------------------------------------------------------------------- -- Power Center Repository Service - Dev -- --------------------------------------------------------------------------- -- DROP USER "DEV_REPO" CASCADE; CREATE USER "DEV_REPO" IDENTIFIED BY "admin" DEFAULT TABLESPACE DEV TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON "DEV" ACCOUNT UNLOCK; GRANT INFA_OWNER TO "DEV_REPO"; GRANT "CONNECT" TO "DEV_REPO"; GRANT "RESOURCE" TO "DEV_REPO"; GRANT CREATE ANY VIEW TO "DEV_REPO";

[@sourabhmathametician]

+GoGeeko Hi can i get these scripts as i dont see in comments.