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="">

How to get even odd records in analysis of OBIEE11g

How to get even odd records in analysis of OBIEE11g


Step 1:- First we need to create an analysis report
            add any extra column and click on Edit Formula

MOD(RCOUNT(1),2)

Click Ok and Save The report.

Then Filter in the particular column 

MOD(RCOUNT(1),2)=1

OR

MOD(RCOUNT(1),2)=2

Run the report and you will get in your wishes as even or odd

Thanks