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
Define mapplet?
What are the issues you have faced in your project? How did you overcome those issues?
Explain constraint based loading in informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
r u done any partitions in ur project?
Write the unconnected lookup syntax and how to return more than one column.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Define Pmrep command?
How to elaborate powercenter integration service?
Different circumstance which drives informatica server to expel records?
Clarify the utilization of aggregator cache record?
What's the layout of parameter file (what does a parameter file contain?)?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is song in infrmatica...?