If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?
- 8 Answers
- 28497 Views
- HeadStrong, TCS, I also Faced
- E-Mail Answers
Answer Posted / rama krishna
Hey man ... first ofall u should need to mention that,
wether u r applied any commit or not.
with out apply any commit, How can u recover the session
yar?
ur quwstion is not valid. if u want exactly improve the
performence, then u must use commit points& commit
intervels.
if u really apply any commit,then if it fail according to u
at 10000 records, then u can recover remaining records by
using OPB_SRVR_RECOVERY table.
Hai friends am i correct ? think once
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Can you generate sequence numbers without using the sequence generator transformation?
Enlist the tasks for which source qualifier transformation is used.
Can we create a Integration service without a Repository service and vice versa?
How to load the data from a flat file into the target where the source flat file name changes daily?
How might you approve all mappings in the archive all the while?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the difference between source qualifier transformations source filter to filter transformation?
How can one identify whether mapping is correct or not without connecting session?
Whats there in global repository
What is a repository? And how to add it in an informatica client?
Explain your project of banking domian.
What is the sql query overwrite in source qualifier in informatica
