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


Please Help Members By Posting Answers For Below Questions

Where are the source flat files kept before running the session?

827


How to partition the Session?

839


How to update a particular record in target with out running whole workflow?

1347


Target increases every day even though no new record was inserted

1331


What is meant by lookup transformation?

788


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

882


Explain constraint based loading in informatica

827


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1721


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

3775


What do you mean by enterprise data warehousing?

818


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

964


Does an informatica transformation support only aggregate expressions?

796


What differs when we choose the sorted input for aggregator transformation?

786


How you prepared reports for OLAP?

1349


What is meant by lookup transformation? Explain the types of lookup transformation?

735