You transfer 100000 rows to target but some records get discard. How wil you trace them? and where its get loaded?

Questions by phanimv   answers by phanimv

Showing Answers 1 - 10 of 10 Answers

sn3508

  • Oct 25th, 2006
 

In the session - target properties, the last two attributes 'reject file directory' and 'reject filename' tells where the bad file (file with rejected records) is located. 

  Was this answer useful?  Yes

mohan

  • Nov 19th, 2006
 

 by using session recovery in 2 metods

start the sission again when informatica server not isssued any commits

trancate the table and run the sessionagain

  Was this answer useful?  Yes

ravi guturi

  • Jan 5th, 2007
 

Yes, we will find out discarded rows by using row indicator and coloum indicator..

Row inidicator:DONT

D-valid

O-overflow

N-null

T-truncate

Column Indicator:0123

0-insert

1-update

2-delete

  Was this answer useful?  Yes

Session failed after loading 10000 records, opb_server_recovry file loads the records, it maintains the record id, correct the error again run the session , session will take 10001 record on words

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions