Interested to Buy Any Domain ? << Click Here >> for more details...
If a session fails after loading of 10,000 records in to the
target. How can you load the records from 10001 th record
when u run the session next time?
- 4 Answers
- 19070 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rekha
U CAN DO IT BY PERFORMANCE RECOVERY
WHEN THE SERVER RUNS THE RECOVERY SESSION , SERVER READS
THE DATA FROM OPR_SRVR_RECOVERY TABLE AND NOTES THE ROW ID
OF THE LAST ROW COMMITTED TO THE TARGET TABLE ,THEN
INFORMATICASERVER READS THE ENTIRE SOURCE AGAIN AND PROCESS
THE DATA FROM NEXT ROW
BY DEFAULT PERFORMANCE RECOVERY IS DISABLE ,HENCE IT WONT
MAKE ANT ENTRIES IN TO OPR_SRVR_RECOVERY TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / swetha
As explained above informatcia server has 3 methods to
recovering the sessions.Use performing recovery to load the
records from where the session fails.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / srini
By setting session property as Resume last check point you
can acheive the same.Make sure that all recovery tables
PM_RECOVERY,PM_TGT_RUN_ID is created in the target database
or Realtion connection User have the
create,grant,insert,update previliages on target database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ambarish
In the workflow manager you have option go to workflow----
>EDIT---check this box suspend on error
if the work fails after loading 10000 records with error
you can correct the error and restart the workflow which
will load strating from 10001.
| Is This Answer Correct ? | 0 Yes | 2 No |
How many repositories can we create in Informatica?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
What is the surrogate key?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
how i will stop my workflow after 10 errors
what is the diff b/w cached and unchaed look ups
What is an aggregator transformation? it is active why cant it be passive explain?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
what is sql override?what is the use of it?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
Teradata 
