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 / swetha
As explained above informatcia server has 3 methods to
recovering the sessions.Use performing recovery to load the
records from where the session fails.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a predefined event?
What is an unconnected transformation?
What are connected or unconnected transformations?
What are the designer tools for creating transformations?
Explain the different dimensions.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How do you load only null records into target?
How to do unit testing in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
On which transformations you created partitions in your project?
What is the cumulative sum and moving sum?
What is data transformation manager process?
Informatica settings are available in which file?
What is confirmed fact in dataware housing?
Briefly define reusable transformation?