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


Please Help Members By Posting Answers For Below Questions

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3773


What is the scenario which compels informatica server to reject files?

812


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1524


What is the cumulative sum and moving sum?

950


Why update strategy and union transformations are active? Explain with examples.

938


What will be the approach?

752


Briefly describe lookup transformation?

779


what is $$$$?

1924


Can informatica load heterogeneous targets from heterogeneous sources?

929


waht type of interface is used for testing the data in informatica

2005


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.

2093


What is domain and gateway node?

915


What if the source is a flat-file?

807


Write the unconnected lookup syntax?

825


Explain the different lookup methods used in informatica?

787