Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 8 September 2013

Debugging in Informatica


By on 09:32:00




Mappings Menu -> Debugger -> Start Debugging or Press F9.
Debugging in Informatica
Debugging in Informatica



Click on NEXT.



Select the Server and Session Type.
Debugging in Informatica
Debugging in Informatica



Assign the Informatica Server serv.

Note: The Designer does not have access to Production Tool like Workflow Manager. To test his session, he creates a debug session instance for the mapping.

Question: Where the reusable sessions are prepared?

Answer: In Task developer



Suppose a session is already prepared in the W.F.Designer (non-reusable)

Select the option 

Use an existing session instance for this mapping.
Debugging in Informatica
Debugging in Informatica

Check the box Discard target data

Once the test is completed, the data will be removed from the target.
Debugging in Informatica
Debugging in Informatica



Output Window: 

Server initialized

Server Ready

Server initialization completed.

DSQ Execution Order:

1: SQ_EMP

Server is Ready.

No breakpoints to send to the server.
Debugging in Informatica


Debugging in Informatica
Debugging in Informatica



Target Instance

Instance

Mapping Menu -> Debugger -> Next Instance or Press F10
Debugging in Informatica
Debugging in Informatica


Debugging in Informatica
Debugging in Informatica



Instance gets populated with SQ data.

Press F10

Instance gets populated with Transformation data.
Debugging in Informatica
Debugging in Informatica


Debugging in Informatica
Debugging in Informatica



4 comments:

  1. I keep getting below error trying to run debugger. How to resolve this?
    PETL_24049 Failed to get the initialization properties from the master service process for the prepare phase [Session task instance [SDE_JDE_Inventory_Daily_Bal_Fact_Full]: Unable to read variable definition from parameter file

    ReplyDelete
  2. I assume you are running OBIA informatica mapping with the source of JD Edwards.

    This is the one of most common problem,check overridempltvarwithmapvar as been set to yes with correct spelling.

    Refer the below link

    http://mkashu.blogspot.in/2013/08/overridempltvarwithmapvar-in-informatica.html

    ReplyDelete
  3. Also check disable bulk mode in informatica

    http://mkashu.blogspot.in/2013/09/disable-bulk-mode-in-informatica.html

    ReplyDelete
  4. once you changed overridempltvarwithmapvar and disable bulk mode. restart the informatica repository and execute you execution plan.

    Hope it helps

    ReplyDelete

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)