Category Archives: Informatica

Relational Connection

STEP1: In Work Flow Select CONNECTIONS > RELATIONAL.   Relational Connection STEP 2: Click on : New… SELECT SUBTYPE : ORACLE STEP3: Create a SOURCE Connection. Provide a name to the source connection i.e., OLAP_INFRA Enter USER NAME i.e., INFRATRAIN(schema name) Enter CONNECT STRING : used database name Enter PASSWORD (schema password) Select CODE PAGE 

Read More