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 / bsgsr

hi, suresh,
go for session recovery if you run in normal mode.
if it is a bulk mode session only option is to truncate the
table and run the session again.

Is This Answer Correct ?    23 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which one is better performance wise joiner or look up

602


What is transformation?

632


Differentiate between router and filter transformation?

591


What are the different types of olap? Give an example?

543


What are the different ways to implement parallel processing in informatica?

835






What are the different components of powercenter?

551


How to do the error handling of if ur source is flatfiles?

1483


Explain the scenario which compels informatica server to reject files?

627


Under which circumstances, informatica server creates reject files?

572


What is the meaning of decode in informatica?

626


What is the need of an ETL tool?

616


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

545


What is the use of an aggregator cache file?

663


What are the settings that you use to configure the joiner transformation?

588


what are factless facts? And in which scenario will you use such kinds of fact tables.

1287