Informatica Workflow Succeeded But Session Failed

Sometime it happens like Informatica session got failed but Workflow will show as succeeded. If you are running mappings though DAC , DAC will not stop execution as Workflow got succeeded. So in that case it is very difficult to find out the failed mappings. So to control the DAC and to get the actual status of mapping we need to enable a option , "Fail parent if this task failed" in session level.

Open session and enable the below showed options.

Enjoy and stay well !! :)

Informatica Issue: ORA-01438

Sometime we used to get an error while running an Informatica workflow as below.

Error:

ORA-01438 : Value larger than specified precision allowed for this column.

Cause:

Datatype defined for the column is not as per the data from coming from source.

Solution:

Change the datatype NUMBER(x,y) to NUMBER.


Enjoy and stay well !! :)

OBIEE 11g: Tool-tips

We can have the tool-tips in multiple places in BI. Tool-tips show the preview with a bit of description which will help user to know about the dashboards or reports whenever they will move the mouse over it.  We can put tool-tips in Dashboard, Dashboard page, Report title, Column heading, etc.  Developer can provide a brief description about the dashboard/reports.

To provide the tool-tips in dashboard level, go to catalog and select the particular dashboard then go to properties of the same. You will get a section called “Description”, where you can write down the brief description about it.  Need to do the same for dashboard page or report title as well.

Now if you want to provide tool-tips on a column heading you need to write a bit of HTML code.

You need to write the below code in Column heading and check the Contain HTML heading option .

<span title="Difference between PR Approval Date and PO Approval Date">Days Taken</span>

Here, "Difference between PR Approval Date and PO Approval Date" will show as preview on column heading.
           "Days Taken" will be the column name. 

Enjoy and stay well !! :)