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
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What's the layout of parameter file (what does a parameter file contain?)?
What is sq transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How we can create indexes after completing the loan process?
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 the procedure for creating independent data marts from informatica 7.1?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are multi-group transformations?
What is the benefit of session partitioning?
What is the function of aggregator transformation?
What is exclusive and normal mode for repository services?
Write the different tools in the workflow manager?
What is rank transform?