Informatica - The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 11 of 312

The difference between Oracle Sequence
Generator and Informatica Sequence Generator?
Which is faster in performance?
Which is best to use?

Total Answers and Comments: 4

Last Update: June 25, 2007 Asked by: Deshaireddy

Sponsored Links

Best Rated Answer

—

Submitted by: Jagadeesh

Good Question... But in any informatica project we will never use oracle seq generator... Due to lot of reasos.

1. Your question itself limited to oracle.

2. It shoud fire this query at datbase level and it should retrive that corresponding data to transformation.

3. It is not easy to handle complex transforamtions

4. U can't run same time same session more than one time..(Very IMP)

like this lot of diff are there...

SO no one will use this seq generator at oracle level

Better to use at informatica level...

If u want further discussion let me know..

I will explain about performance of "informatica and oracle" related to cache's

From

Jagadeesh

Above answer was rated as good by the following members:
tinku007

April 03, 2006 04:12:55

Jagadeesh

RE: The difference between Oracle Sequence Gener...

Good Question... But in any informatica project we will never use oracle seq generator... Due to lot of reasos.

1. Your question itself limited to oracle.

2. It shoud fire this query at datbase level and it should retrive that corresponding data to transformation.

3. It is not easy to handle complex transforamtions

4. U can't run same time same session more than one time..(Very IMP)

like this lot of diff are there...

SO no one will use this seq generator at oracle level

Better to use at informatica level...

If u want further discussion let me know..

I will explain about performance of "informatica and oracle" related to cache's

From

Jagadeesh

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 04, 2006 12:02:59

Srinu

RE: The difference between Oracle Sequence Gener...

Thanks Jagadeesh,

Can U explain performance of informtica and oracle.

Is this answer useful? Yes | No

June 05, 2007 15:18:10

rsannu2k

Member Since: June 2007 Contribution: 4

RE: The difference between Oracle Sequence Gener...

Good question,

Informatica Sequence Gen, uses its server cache and generates the sequence numbers and uses it along with the load, which happens at the same time, remember it will use the Informatica Cache, which is comparatively not that big with transformations like Lookup and others.... Advantage is very easy to create and use it when we are inserting into "multiple targets"!, Infa seq is part and parcel of mapping(s).

but in case of Oracle Sequence, we need to maintain it separately along with tables and other objects, and the main question is how will you access it everytime in every mapping? solution is there, but do you recommend it?

Is this answer useful? Yes | No

June 25, 2007 09:14:37

N SRIRAM K

Member Since: May 2007 Contribution: 115

RE: The difference between Oracle Sequence Gener...

No doubt, Sequence generator transformation will be fast in Informatica.

Is this answer useful? Yes | No

Go To Top