Geeks Talk

Prepare for your Next Interview




Informatica related

This is a discussion on Informatica related within the Data Warehousing forums, part of the Databases category; hi, What is the deadlock in informatica?can any one explain? regards som...


Go Back   Geeks Talk > Databases > Data Warehousing

Informatica related Informatica related

Register FAQ Members List Calendar Mark Forums Read

Reply

 

Thread Tools Display Modes
  #1 (permalink)  
Old 07-03-2008
Junior Member
  
Join Date: Jul 2008
Posts: 2
Thanks: 0
Thanked 2 Times in 1 Post
soma_ss2000 is on a distinguished road
Informatica related
hi,

What is the deadlock in informatica?can any one explain?



regards
som
Reply With Quote
The Following 2 Users Say Thank You to soma_ss2000 For This Useful Post:
Sponsored Links
  #2 (permalink)  
Old 07-03-2008
Junior Member
  
Join Date: Jun 2008
Location: Bangalore
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
jacky4u is on a distinguished road
Arrow Re: Informatica related
Typically this occurs when one transaction has a lock on a resource that another transaction is trying to obtain. This can be resolved by managing the workload schedule
Reply With Quote
  #3 (permalink)  
Old 07-03-2008
Junior Member
  
Join Date: Jun 2008
Location: Bangalore
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
jacky4u is on a distinguished road
Arrow Re: Informatica related
Calling all the MS-OLAP objects at once will cause an error in the Analysis Services server and all the objects will be in the state of Unprocessed. The Informatica side has to call the dimensions first and only then the cubes. The cubes must not be called all at once if they have relationships between them. This will cause deadlock.
Reply With Quote
  #4 (permalink)  
Old 07-09-2008
I am the DON
  
Join Date: Apr 2006
Location: Just on Earth with all....
Posts: 102
Thanks: 1
Thanked 31 Times in 24 Posts
sanghala is on a distinguished road
Re: Informatica related
Quote:
Originally Posted by soma_ss2000 View Post
hi,

What is the deadlock in informatica?can any one explain?
Friend Som,

Can you reply back whether you mean to say either one of these ?

  • DEADLOCK on database level
  • Write Lock on Informatica level

Both will be caused because of the unautorized access on which the object is locked for write by other resource.

Hope its clear for you..!

And Please post the thread with proper subject not in a VAGUE format
__________________
Sanghala
www.dwforum.net - A Great resource for Data Warehousing Professionals

If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Reply With Quote
Reply

  Geeks Talk > Databases > Data Warehousing

« Data Warehousing and Data mining | Difference between metadata and data dictionary »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
related to PO kanti Oracle Apps 3 03-10-2008 08:10 AM
Related to research Thangamani.P C and C++ 0 10-05-2007 09:05 AM
QTP related rvasantha QTP 3 08-21-2007 05:47 AM
c++ related. kamanianil PeopleSoft 1 07-31-2007 05:30 AM
Java related annaannam Java 1 05-25-2007 05:19 AM


All times are GMT -4. The time now is 08:24 PM.

Contact Us - Geeks Discussions - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved