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
- 12279 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 |
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
How can we remove the duplicates from flat file source?
What is a dimensional model?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to load relational source into file target?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
difference between repository database and repository service?
In a sequential batch can u run the session if previous session fails?
select count(1) from emp? what is the o/p?
Can you use one mapping to populate two tables in different schemas
wht is cdc?how to use it in creation of mappings?
Teradata 
