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
- 12226 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
How big was your fact table
How to elaborate powercenter integration service?
Global and Local shortcuts. Advantages.
What is the advantage of informatica?
Explain the etl program with few examples.
How to convert multiple rows to single row (multiple columns) in informatica
Define mapplet?
What are the differences between source qualifier and joiner transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What all join we can perform in LOOKUP transformation?
list out all the transformations which use cache?
What is a filter transformation?
Is there any way to read the ms excel datas directly into informatica?
How will the document be delivered to me?
Can u generate reports in Informatica?
