If a session fails after loading of 10,000 records in to the
target. How can you load the records from 10001 th record
when u run the session next time?
Answer Posted / srini
By setting session property as Resume last check point you
can acheive the same.Make sure that all recovery tables
PM_RECOVERY,PM_TGT_RUN_ID is created in the target database
or Realtion connection User have the
create,grant,insert,update previliages on target database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Tell me about MD5 functions in informatica
Describe an informatica powercenter?
Explain what is informatica metadata and where is it stored?
What is target designer and target load order?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What do you understand by SOA of Informatica?
can we override a native sql query within informatica? How do we do it?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Define update strategy?
how to create user defined function (udf) in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the reusable transformation?
What is workflow? What are the components of the workflow manager?