If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
Answer Posted / 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 |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differentiate between router and filter transformation?
Under what condition selecting sorted input in aggregator may fail the session?
What is the difference between source qualifier transformations source filter to filter transformation?
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?
What is a surrogate key?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to generate sequence numbers?
how to load dimension table and fact table. plz tell me the steps.
Explain the use of aggregator cache file?
list out all the transformations which use cache?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Why update strategy and union transformations are active?
What is union transformation?
Design a mapping to load a target table with the following values from the above source?