when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?

Answer Posted / powerstar

session recovery works much better if it is run in normal mode.
If the load type is bulk mode, then session recovery is compromised.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a connected look up and unconnected lookup?

574


What is the Process to creating lookup transformation in informatica

586


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1619


 Informatica Checkpoints

2857


What do you understand by a term domain?

670






HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1477


What are some examples of informatica etl programs?

537


What is aggregate cache in aggregator transformation?

635


Explain how many types of dimensions are available in informatica?

595


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6411


What is the way to execute pl/sql script using informatica mapping?

963


What are the various types of transformation?

646


Explain what is informatica metadata and where is it stored?

610


what is the difference between informatica6.1 and infomatica7.1

1719


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1132