If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?

Answer Posted / gayathri

In session properties we have "suspend on error" option is
there. It starts from the failed task not from the begining.

Is This Answer Correct ?    7 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the types of transformations?

609


Different circumstance which drives informatica server to expel records?

565


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7689


wf dont have integration severances how you can run?

1549


What is domain in terms of informatica?

574






Could you explain what is enterprise data warehouse?

567


How are the sources and targets definitions imported in informatica designer?

689


What is option by which we can run all the sessions in a batch simultaneously?

677


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

615


Explain pushdown optimization and types in informatica

676


What is data transformation manager process?

630


where to store informatica rejected data?

695


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6497


What is fact table? Explain the different kinds of facts.

623


Explain incremental aggregation in informatica

661