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

what is INFORMATICA TESTING process

1842


Define the various join types of joiner transformation?

561


Briefly define reusable transformation?

624


What is the need for an etl tool?

638


Design a mapping to load a target table with the following values from the above source?

880






What do you mean by blocking transformation?

585


Explain sessions. Explain how batches are used to combine executions?

597


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2069


Mention few power centre client applications with their basic purpose?

538


Explain target update override in informatica

631


What are the static cache and dynamic cache in informatica?

718


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

633


What is the surrogate key?

644


How many input parameters can exist in an unconnected lookup?

992


wat are deployement groups in informatica, how it will be used for developers

1258