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
- 12411 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shiva
just truncate table once and run the session again (or)
in session properties just checke the recovery stratagy as
resume from last check point
if i am wrong plese currecct me
| Is This Answer Correct ? | 4 Yes | 1 No |
"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 |
Answer / guest
use dynamic lookup cache so that u can load the data after
load 50 records
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sunny
Did you check if there is any filter in between ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lakshmi
If no errors, check if you have set "test rows" to 50 in session property.
| Is This Answer Correct ? | 0 Yes | 0 No |
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
how to join the two flatfiles using the joiner t/r if there is no matching port?
How the informatica server sorts the string values in Rank transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
What is intricate mapping?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Tell me one complex query in oracle ?
If u r using dynamic cache lookup port will be thier in thet which option u will select
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Can we create two repositories on same database instance in oracle?
Teradata 
