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
- 31088 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 |
Suppose we do not group by on any ports of the aggregator what will be the output?
sorce is a flatfile only 1st and last row should insert to target how will u do?
My source table having some records ,i want load 1st record and last record into one target?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
what is left outer join?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Explain why we use partitioning the session in informatica?
How would you copy the content of one repository to another repository?
What is informatica? What exactly are the practical uses in real world
Separate from an archive server and a powerhouse?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Teradata 
