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
what is INFORMATICA TESTING process
Define the various join types of joiner transformation?
Briefly define reusable transformation?
What is the need for an etl tool?
Design a mapping to load a target table with the following values from the above source?
What do you mean by blocking transformation?
Explain sessions. Explain how batches are used to combine executions?
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
Mention few power centre client applications with their basic purpose?
Explain target update override in informatica
What are the static cache and dynamic cache in informatica?
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?
What is the surrogate key?
How many input parameters can exist in an unconnected lookup?
wat are deployement groups in informatica, how it will be used for developers