Informatica Interview Question.

1.        Lookup cache.

2.       Source and Target mapping ,Raw movement

3.       Informatica change history ( Check in & Check out)

4.      Pre-sql and Post SQL in Informatica

5.       Where we can check user lock

6.      Informaica is service oriented /servre

7.       Check infromatica rung port.

DAC

EP (Execution Plan ) ,ETL ( Extract Transform and Load ) & DAC Load

Execution plan   - >  Execution plans are subject areas that are used to execute ETL processes

Scheduler          ->    Based on requirement we can schedule EP here .

 Source system ; Data pulled from source to target Data ware house DB.

  

Loading Tables

   

These are the steps for GUID Refresh

1. change the nqserver for FMW GUID update set it to YES

>bicfg

vi NQSConfig.INI

FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

2. Change the instanceconfig.xml for GUID update on presentation side

> pscfg

vi instanceconfig.xml

<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>

3.stopall opmn components

> bi

./op* status

./op* stopall

4.start the opmn servers

> ./op status

> ./op* startall

5.Wait for sometime as the GUID Refresh would be started in the backgroud,

you can verify this by tailing the upgrade log

>pslog

tail

6. After sometime the presentation services would be down when the GUID Refresh is complete

7. >bi

./op* status

to see if the ps is down

8. Revert back the changes in Biserver config and ps server config

comment the guid part in ps and FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;

<!-- <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs> -->

9. >bi

./op* startproc ias-component=coreapplication_obips1

./op* status

User Management

To model /Mimic other user in OBIEE in weblogic.

Login to weblogic console -> Security Realms -> myrealm -> User and Groups -> Users -> Select the user (To create click on create) -> Check the groups

Check the roles assigned to the user in OBIEE .

<domain home>/config/fmwconfig

/u01/oracle/product/11116_biee_OBIP11/user_projects/domains/OBIP11_domain/config/fmwconfig

View system-jazn-data.xml

:/planninguser

<app-role>

                        <name>KCI_OBI_OPS_ADVANCED_GLOBAL</name>

                        <display-name>KCI_OBI_OPS_ADVANCED_GLOBAL</display-name>

                        <description>Creates/Reads Operations Reports for all countries</description>

                        <guid>0CDC2E80245611E2AF5C95DD452FF562</guid>

                        <class>oracle.security.jps.service.policystore.ApplicationRole</class>

              <members>

                     <member>

                                <class>weblogic.security.principal.WLSGroupImpl</class>

                                <name>KCI_OBI_OPS_ADVANCED_GLOBAL</name>

                      </member>

                      <member>

                                <class>weblogic.security.principal.WLSUserImpl</class>

                                <name>planninguser</name>

                       </member>

              </members>

  </app-role>