As we know Power Center 8.x & 9.x supports grid architecture,
but I was curious to know about Informatica Power Center behavior with Oracle
Gird (RAC) as repository. Below are few questions that popped up in my mind, and
over the weekend had a chance to discuss with my friends.
Oracle RAC:
Oracle Real
Application Clusters (RAC) enables 24 x 7 availability of database applications.
RAC provides two method of failover for reliable data access.
- Connection failover
- Transparent Application Failover
(TAF)
1.
On failover, what happens within repository service
(Oracle RAC)?
Repository Service is starting and
detects that one of the instances of the RAC has gone down, and then connection
is automatically transferred to other active nodes.
2.
Does Oracle gird functionality anyway help’s
Power Center Gird?
There is no impact on application logic,
but OCI libraries helps in migrating database connection from one database node
to other incase of failover.
3.
Do we need to configure anything within
Informatica?
Informatica does not have special
parameters to handle Oracle RAC failover instance. It must be configured in
Oracle.
4.
Why Informatica recommends only Connection failover,
and not TAF?
When the Repository Service writes to the
repository tables and before the commit occurs, the connection is failed over,
then the inserts alone will be rolled back, potentially leaving the table in a
corrupt state. The failover
within RAC should be transparent to Informatica. If any update or insert fails
in the middle and RAC didn't failover, Oracle would return failure status to
Repository service.
The TAF guarantees session failover.
However, it does not guarantee the same for DML statements.
5.
Does Oracle RAC support the failover of DML
statements?
No.
Yet to get opportunity to really work on
Oracle RAC environment, but completely understood the concept behind the
integration. Please if you have any
questions related to RAC integration post it here, I will try to understand
and answer you. Thanks!!
Dear mr Ramesh,
ReplyDeleteAs usual, connection from Informatica to RAC should be connect to SCAN of RAC or just connect to 1 single node in RAC. Which one is better ?
SO thanks
Ch
Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!
ReplyDeletesap online training
software online training
sap sd online training
hadoop online training
sap-crm-online-training
This is one awesome blog article. Much thanks again.
ReplyDeleteI really enjoy the blog.Much thanks again. Really Great.
oracle online training
sap fico online training
dotnet online training
qa-qtp-software-testing-training-tutorial
ReplyDeleteVery nice and informative blog.Info is very good..please visit
http://www.tekclasses.com/
too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 7 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, informatica mdm training in hyderabad
ReplyDeleteIt was really a nice article and i was really impressed by reading this Informatica Online Training Hyderabad
ReplyDeleteNice Information Keep updatingInformatica Online Course
ReplyDelete