If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
Answers were Sorted based on User's Feedback
Answer / bsgsr
simple. in session properties configure the session to
enable recovery. it then create s a database log file which
contains the rowids ot all records committed to the target.
when you run recovery session it checks with the log file
the last rowid committed to the target and writes to the
target from the next rowid. condition the session is
configured to run in a normal mode.
Is This Answer Correct ? | 42 Yes | 0 No |
Answer / rao
one option is session recovery.
or
select * from select rownum from tablenaem) where rownum>10000
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / mohit
After running the session once it will load 10000 records
and it will fail afterwards then we can take the minimum
and maximum count of the number of records in the target in
a paramter and we can specify these parameters in the SQl
override of sql qualifier so once again when it will run
the session then it will take those minimum and maximum
values from the parameter and will specify a condition in
the sql overide that dont take any values from min to max
and take rest of the values so in this case the minimum
will be 1 and the maximum will be 10000 so the sql overide
will take the values after 10000 i.e 10001.
select * from employee where value is not in between $$min
and $$max
I think may be this can be a solution
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anil
mr rao is answer is correct .another way use exp t/r put it
>1000
Is This Answer Correct ? | 0 Yes | 7 No |
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
What is source qualifier?
What are mapplets? How is it different from a Reusable Transformation?
How to display First letter of Names in Caps?
Tell me about Propagate functions in informatica
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
How to extract original records at one target & Duplicate records at one target?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
How can we delete duplicate rows from flat files?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
In what scenario we use to improve session performance by pushdown optimization?can any one give example?