Informatica related

hi,

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



regards
som

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

[COLOR="SeaGreen"]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 [B]deadlock[/B]. [/COLOR]

[QUOTE=soma_ss2000;32215]hi,

What is the deadlock in informatica?can any one explain?
[/QUOTE]

Friend Som,

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

[B][LIST][*]DEADLOCK on database level[*]Write Lock on Informatica level[/LIST][/B]
[COLOR="RoyalBlue"]Both will be caused because of the unautorized access on which the object is locked for write by other resource.[/COLOR]

Hope its clear for you..!

[COLOR="Red"][B]And Please post the thread with proper subject not in a VAGUE format[/B][/COLOR]