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 / ambarish
In the workflow manager you have option go to workflow----
>EDIT---check this box suspend on error
if the work fails after loading 10000 records with error
you can correct the error and restart the workflow which
will load strating from 10001.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between router and filter?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is an Integration service in Informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Tell me about MD5 functions in informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain the code page compatibility?
What are the transformations that are not supported in mapplet?
Quickly characterize reusable change?
What is the difference between writing a joiner query in ANSI style and THETA style?
Mention few power centre client applications with their basic purpose?
What do you mean incremental aggregation?
Why filter transformation is an active one?
What are the differences between source qualifier and joiner transformation?