[INFORMATICA] - How to Create a Target Table in Informatica?

If you have created Target table just using the Target designer and wondering how to create it in actual database then here are the steps.

In the target designer --> select the table You created ---> choose generate sql under target menu
 -->choose your dsn for database -->click edit and generate sql. 

[INFORMATICA] - The specified DSN contains an architecture mismatch between the Driver and Application.

I am trying to connect to oracle using power center designer 9.5.1 > Import Database source option and I get this error "The specified DSN contains an architecture mismatch between the Driver and Application.

" .

Windows 7 OS 64 bit

Oracle 11 G Release 2 64 bit

Informatica Server 9.51 64 bit

Informatica Client 9.5.1 32 bit [because there is no 64 bit exe for client]

I tried to run

c:\windows\syswow64\odbcad32.exe and I didn''t see an oracle entry to create user or system dsn so installed ODAC 32 bit fromhttp://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html then I see an oracle entry in here as well now BUT when I try to connect test connection to oracle it fails. See second snapshot. May be because it i 32 bit driver trying to connect oracle 64 bit database doesn't work.

I tried to run

c:\windows\system32\odbcad32.exe , I see an oracle entry to create user or system dsn. Test connection to oracle works fine. From Start>Programs> ODBC is using the exe from this location on 64 bit windows OS

To Resolve this issue You can use : Data Direct 6.0 Oralce Wire Protocal Driver in informatica

   

click on Test connection--->OK---> APPLY

[INFORMATICA] - Steps to install Informatica Powercenter 9.5 in Windows 8 or windows 8.1

Here am going to give the step by step process to download and install Informatica Powercenter 9.5.x in Windows 8/8.1

Step 1 : Define Schema in Oracle DB for Domain repository:
********************************************************************************************************
Where teaneck_ts is your tablespace(you can choose your own tablespace name)
Where teaneckdb is your own username(you can choose your own tablespace name)
Skip step 1 if already the repository schema in place.
**********************************************************************
CREATE TABLESPACE TEANECK_TS DATAFILE 'C:\app\<your computer name>\oradata\orcl\teaneck_ts.dbf' SIZE 100M AUTOEXTEND ON MAXSIZE 500M;
CREATE USER teaneckdb
IDENTIFIED BY teaneckdb
DEFAULT TABLESPACE TEANECK_TS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
ALTER profile DEFAULT limit password_life_time UNLIMITED;
Create role SSE_ROLE;
Grant connect, resource to SSE_ROLE;
Grant select any table to SSE_ROLE;
Grant create session to SSE_ROLE;
Grant insert any table, delete any table, update any table to SSE_ROLE;
GRANT SSE_ROLE TO teaneckdb;
GRANT GLOBAL QUERY REWRITE TO teaneckdb;
GRANT CREATE MATERIALIZED VIEW TO teaneckdb;
GRANT CREATE TABLE TO teaneckdb;
GRANT CREATE ANY VIEW, DROP ANY VIEW TO teaneckdb;
GRANT CREATE ANY SEQUENCE, DROP ANY SEQUENCE TO teaneckdb;
GRANT CREATE ANY INDEX, DROP ANY INDEX TO teaneckdb;
GRANT UNLIMITED TABLESPACE TO teaneckdb WITH ADMIN OPTION;



Step 2 : Copy and paste the entire SOURCE folder to INFA HOME folder.
*********************************************************************************
1.Download Informatica 9.5.1 from Oracle

    -- Follow steps given in This_Link to download and extract setup files

2. Copy SOURCE folder from 951HF2_Server_Installer_winem-64t folder

3. Paste the SOURCE folder to C:\Informatica\9.5.1   (INFAHOME)

Step 3: GUI is not compatible for Windows 8.1. We have to choose the cmd line execution to create the domain.
*********************************************************************************
Go to INFAHOME(C:\Informatica\9.5.1\Source\isp\bin) in cmd prompt and execute the below command

infasetup.bat defineDomain -da localhost:1521 -dt Oracle -du teaneckdb -dp teaneckdb -ds ORCL -dn domain_localhost -ad administrator -pd <yourpassword> -ld C:\Informatica\log -nn nodelocalhost -na localhost:6000 -mi 6000 -ma 6005 -rf nodeoptions.xml

where du teaneckdb is your oracle repository and du teaneckdb is password.
<Yourpassword> Administrator password.

Step 4 : Start the domain.
*********************************************************************************

Go to C:\Informatica\9.5.1\Source\tomcat\bin in CMD prompt(in INFAHOME)

Run infaservice.bat startup

C:\Informatica\9.5.1\Source\tomcat\bin> infaservice.bat startup

The domain will be kicked off.

Step 5: In browser type the URL
********************************************************************************
http://localhost:6000

This will take you the informatica administrator console.

Step 6 : Install Informatica Client by making compatibility of Windows 7.
*********************************************************************************

Go to folder "951HF2_Client_Installer_win32-x86\Client"

Right click "install.exe" and choose properties

In the compatibility tab choose "Windows 7" and click apply

Now double click the exe file and install it.

********************************************************************************

Step 7: Configure Environment variables

Set varaible INFA_HOME to "C:\Informatica\9.5.1\Source"

Set variable LIBPATH to "C:/Informatica\9.5.1\Source\server\bin"

********************************************************************************

Step 8: Update versions of Plug-ins

when the plug-ins are not registered to the domain and the version of the plug-ins need to be updated so perform the following steps:

1. Shut down the domain.
2. From the $INFA_HOME/server/ directory, run the command: "infasetup.bat validateandregisterallfeatures".
3. Once the command executes successfully, restart the domain and Model Repository Services and connect from the Developer client.

********************************************************************************

You are ready to work in Windows 8.1.

The SQL Model Clause

Refer http://www.dba-oracle.com/oracle_news/10g_dw_model_clause.htm

ORACLE-BASE - Oracle9i Mutating Table Exceptions

ORACLE-BASE - Oracle9i Mutating Table Exceptions