I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

Answer Posted / ahalya inturi

"Restart the session" . if the integration service has not issued at least one commit.
(or)
perform "Session Recovery" if the integration service has issued atleast one commit.
the I.S reads row id of last row commited from OPB_SRVR from repository table.
the I.S reads all the data from source , start processing from next row id..
we can perform session recovery when only target load type is normal. it can not support in bulk loading..

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapping debugger?

574


Sequence generator, when you move from develoment to production how will you reset

1410


What is union transformation?

575


How do we call shell scripts from informatica?

599


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1787






How would you copy the content of one repository to another repository?

557


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1466


Explain the pipeline partition with real time example?

655


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699


which one is better performance wise joiner or look up

628


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1854


What is a code page?

716


How to elaborate tracing level?

687


What is Data Caches size?

656


Quickly characterize reusable change?

691