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
- 12167 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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is the -ve test case in your project.
What are the different options available for update strategy?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
wf dont have integration severances how you can run?
What is Index Caches size?
What are connected or unconnected transformations?
Explain why we use partitioning the session in informatica?
What are the new features of informatica 9.x developer?
What is primary and backup node?
can we override a native sql query within informatica? How do we do it?
How to load the data from people soft hrm to people soft erm using informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is an expression transformation in informatica?
