Path of infa variable stored in admin console ...

The workflow [xxxxxx] failed because an operating system profile was not specified and the Integration Service uses operating system profiles. Please check the Integration Service log for more information.

The workflow [xxxxxx] failed because an operating system profile was not specified and the 
Integration Service uses operating system profiles.  Please check the Integration Service log for more information.

I had faced this issue,now i am going to explain wht i did to resolve this.

Edit 
Use Operating System Profiles='YES' 
:)

INFORMATICA - Target Update Override : Updating Target Table without any Primary Keys defined

INFORMATICA - Target Update Override : Updating Target Table without any Primary Keys defined

http://ramakantshankar.blogspot.in/2014/03/informatica-target-update-override.html

OBIEE IMPOTANTS LINKS....

1)OBIEE important directory path:-

http://oraclebisolutions.blogspot.in/2013/02/obiee-11g-important-path-directories.html


2) Fact and Dimension from single fact table.

http://oraclebisolutions.blogspot.in/2013/02/fact-and-dimension-from-single-source.html 

3)Patch in OBIEE11g

http://everythingoracle.com/obieepatch.html


4)Active Directory Authentication.

http://oraclebisolutions.blogspot.in/2013/02/obiee-11g-active-directory-authenication.html 

5) Refresh GUID
http://oraclebisolutions.blogspot.in/2013/01/obiee11g-refresh-guids.html

6) OBIEE Migration security ,roles and gurups
http://www.rittmanmead.com/2011/04/oracle-bi-ee-11g-migrating-security-identity-stores-part-1/

http://oraclebisolutions.blogspot.in/2013/06/obiee-11g-application-roles-migration.html

Informatica Scenarios Based Question

Informatica Scenarios Home

http://www.bullraider.com/database/informatica/scenario

How to Optimize Buffer Memory in Informatica

How to Optimize Buffer Memory in Informatica

1)Buffer Block Size

Buffer Block Size = Largest Row Precision * 100

2)Session Buffer Blocks

Session Buffer Blocks = (total number of sources + total number of targets) * 2

3)DTM Buffer Size

DTM Buffer Size = Session Buffer Blocks * Buffer Block Size / 0.9

How to load the first 3 records from a flat file into a target table in Informatica

Step 1:- create an ETL

In filter transformation 

Give a condition  NEXTVAL<4 p="">