Thursday, February 14, 2008

About me

I did all my education in the Kurnool district of AP, India. After I am out of my college, joined Automatic Data Processing Inc (ADP, Hyderabad) in June 2003 and worked there for almost 2.5 years. I decided to move out and joined Tata Cosultancy Services in October, 2005. I've resigned from TCS and am in Singapore at the moment.
DBMS (Database Management System) was one of the subjects I hated during my engineering (because of all the Normalization rules blah blah). Here now, I end up being a developer in Informatica PowerCenter with more than essential knowledge of Oracle SQL & PL/SQL. The more I learn about Oracle, the more I like it.

8 comments:

Kashif said...

Lookup is really bane on a performance especially if you are looking up 2000 rows in a 10 million table. Your suggestions are awesome.

By the way, can you give a detailed example (with screenshots if possible) of the concatenating lookup example?

Also a question, which has better performance, unconnected lookup or connected lookup?

Radhakrishna Sarma said...

Hi Kashif,

I couldn't check the comments of my blog, so apologies for late reply.

Regarding your question on concatenating lookup example: let us take that you have a requirement to load the source employee flat file into the target employee table. But you need to populate the target table Emp_Name column with the full name of the Employee and you get it from another table called EMPLOYEE_NAMES(empid, first_name, last_name, middle_name).

You want to have full names only for dept 10, 20 and 30. For dept 40 and 50, you don't want full names of employees.

For this you need to go for an unconnected lookup on EMPLOYEE_NAMES table with the the query concatenating them.

If you need you seggregate them again at the calling transformation.

Secondly regarding your question on connected and non-connected lookup performance. They both are lookups so it doesn't matter what you use. But when you want to call it conditionally, go for un-connected lookup.

Cheers
Sarma.

Subhashini said...

ur suggestions are excellent on lookup performance..can i have ur contact no..for my future queries..

thanks a lot..

Subhashini said...

ur suggestions are excellent on lookup performance..can i have ur contact no..for my future queries..

thanks a lot..

Subhashini said...

ur suggestions are excellent in lookup performance

Radhakrishna Sarma said...

Hi Subhashini,

My email address is radhakrishna [dot] sarma [at] gmail [dot] com. Please send a test mail from your email to me, I shall give you my contact details.

Cheers
Sarma

mohit said...

hi,
ure blog is really helpfull for me
can u post some tutorial on how we can connect the informatica with java api's(these api's i found in the client informatica folder).

for past some month i m tryin to do the same but didn't succedded in that

mohit said...

hi
i saw ure blog and its really helpfull for me

Do u have any idea of how we can connect to the informatica power center with java api's or can u post some tutorial regarding this

actually i found some api's in the informatica folder of my client informatica folder and i tried too.
but i couldn't succedded

i want to change all the pre-session and post session command in all the workflows session in a folder and i found that this can be possible with this only.

 
HTML Hit Counters