Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 31152 Views
- HeadStrong, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srikanth
Select the recovery strategy in session properties as
"Resume from the last chk point"
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / guest
using performance recovery to load the target
they are 3 types of performance recovery
1 ) we enable the recovery option in session
2) we put a commit intervel point in session
3) trancate the target and load once again
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lathagarat
First we will get the how many records was loaded in the
target system i.e max(records) (using aggregate
transformation we can get)and incremented from there
onwards.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / chaitanya
On selecting lookup cache as PERSISTENT we can able to use same cache for next session also.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gayathri
In session properties we have "suspend on error" option is
there. It starts from the failed task not from the begining.
| Is This Answer Correct ? | 7 Yes | 7 No |
Answer / basu
I think his question is, he wants to loads incremental. so you can go for Change data capture by using mapping variable/parameters in the SQ query overid
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nidhi
As per me Mr.Rama Krishna is right, every one else is ...
Ms. latha he already mentioned like after loading 10000
records, so there is no need to check again the
max(records),but incremental loading is also one of the ways
i guess..
1)Session recovery
2)Incremental loading are the ways as per my knowledge..
If any 1 think i am wrong plz let me knw..
| Is This Answer Correct ? | 1 Yes | 6 No |
How are the sources and targets definitions imported in informatica designer?
what are types of dimentions?
what are presession,postsession success and postsession failure commands ?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
what is the difference between repository & Intergration service
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
What are the types of metadata that stores in repository?
Teradata 
