What are the circumstances that infromatica server results
an unreciverable session?
Answer / swetha
The source qualifier transformation does not use sorted ports.
If you change the partition information after the initial
session fails.
Perform recovery is disabled in the informatica server
configuration.
If the sources or targets changes after initial session fails.
If the maping consists of sequence generator or normalizer
transformation.
If a concuurent batche contains multiple failed sessions.
Is This Answer Correct ? | 2 Yes | 0 No |
What is deployment group?
What is the use of transformation?
Differentiate between a repository server and a powerhouse?
In dimension and fact table? which one holds big data?
What is CHECK-IN CHECK-OUT. Please explane me?
How to prepared lld.can any one tell me detailed explanetion.
Tell me about MD5 functions in informatica
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What is hash partition?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records