Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 12246 Views
- Patni, I also Faced
- E-Mail Answers
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
What are the informatica performance improvement tips
As union transformation gives UNION ALL output, how you will get the UNION output?
I have a flat file, want to reverse the contents of the flat file
What is a dimensional model?
How many numbers of sessions can one group in batches?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the different types of transformation available in informatica.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Define filter transformation?
What are the tasks that source qualifier perform?
What are roles and groups and benefits of using them?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
In warehouses how many schemas are there?
can you please explain me pre session and post session options?
What is the difference between Active and Passive transformation?
