Informatica Case Study: Execute stored procedure with dynamic input and generate error messages for reporting

Hello Again.Today I am going to share a real case study where it is required to execute a stored procedure using Informatica and stores the output of any potential errors.We have written a stored procedure that will invoke reports from the main frame machine based on inputs, and as a result, a report in the form of PDF will be created. The input for the store procedure will be the report name, which varies. The output, if report name is valid, will...

Read More

OBIEE11G: Basic Navigation On Presentation Service Interface

HelloLast time I briefly went over some of the obvious difference between OBIEE 1OG and 11G in terms of working with the rpd using Admin Tool. This time let's take a general overview on what the front end presentation service looks like in 11G compare to what it used to be like in 10G.For those who have quite a lot of experience with 10G but haven't had hands-on experience working with 11G, I hope this article will help you better relate the things...

Read More

R.I.P Steve Jobs

I have never owned any of Steve's products. I always wanted to but i always came up with excuses to delay my purchase. Now that he is gone, it made me feel sad. Life goes fast and before i realized how many excuses I have made to myself not to do it, it is too late. RIP Mr Jobs... I am still using my old phone, old computer. The next product that I get will guarantee to be one of your greatest creati...

Read More

OBIEE 1O1: An Absolute Beginner's Guide to shortcut the learning

Hello there again! I have been getting a lot of feedback recently from people who are new to OBIEE. One of the most common thing that I am getting is that there are too much information out there for OBIEE and it is too difficult to make sense if you have no OBIEE hands-on experience prior. This is very true. The Internet is a great place to find knowledge and resource for whatever you want, but the amount of information you can find online...

Read More

OBIEE 11G: Basic Repository Navigation Compared to 10G

HelloJust got 11G installed on my PC, it's time to check it out. What I have is 11.1.1.5, which is the second version of the 11G. I wasn't a big fun of 11G when it first came out, partly because I was able to work around most of the issues using 10G, I simply wanted to wait for some time before going into 11G. It gave me a lot of time to hear feedback from other users who are already using 11G. Now looks like 11G is going to be the trend and Oracle...

Read More

Error connecting DB from DAC ORA-12516: TNS:listener could not find available handler with matching protocol stack

I ran into this error a lot recently when running DAC execution plan, which takes some time to complete. Here is the error details that you can get from Informatica session log when the sessions failed:RR_4036 Error connecting to database [Database driver error...Function Name : LogonORA-12516: TNS:listener could not find available handler with matching protocol stackDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [etldw] and connection string [BIQATST].].Upon some researching and some help...

Read More

DAC: Fail to create Index during execution plan run

Hello againHere is something that a beginner may run into every so often when they use DAC to run informatica workflow, which is when the DAC execution plan runs fine except it fails to create table Index after the load. Or it could be shown as the following scenario:The execution plan is completed with several failures of its tasks. We look at the detail of the task and find out that it fails at the last step of creating table Index:We found out...

Read More

A practical intro guide to Oracle Data Admin Console (AKA DAC) Part 5 -- when Index is involved

I decided to add one more part to the previous series about basic working of DAC. I realized that I forgot to address the situation where table Index is involved in the test environment I set up for previous demonstration. It is absolutely worth addressing here but we WILL deal with tables that have indexes.So let's start with the following error scenario:We have task running with completion in DAC:But this workflow is giving an error about Index:As...

Read More

A practical intro guide to Oracle Data Admin Console (AKA DAC) Part 4

Based on everything we have done in Part 3 of the series, we have come to the final configurations, which is to build subject area and execution plan:To creating subject area like mentioned in part 4:The subject area name is MCK_Forklift_SDE and the task being added to it isSDE_MCK1213_FND_LANGUAGES. I had added another task to this subject area previously, therefore we have 2 task entries here in this example. Don't be surprised.Very important,...

Read More

A practical intro guide to Oracle Data Admin Console (AKA DAC) Part 3

In Part 2 we went over the basic setup in DAC, so the next is building tasks: To build task, simply go to Design --> Task --> New: In the 'edit' tab, we start filling in the fields. Notice there are two fields: commend for incremental load and commend for full load. Usually, when creating informatica workflows, there are 2 separate sessions, one for full load and another for incremental load. For simplicity, I only create 1 workflow,...

Read More