If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?
Answer Posted / guest
using performance recovery to load the target
they are 3 types of performance recovery
1 ) we enable the recovery option in session
2) we put a commit intervel point in session
3) trancate the target and load once again
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can we use mapping variables in informatica?
What is Index Caches size?
While migrating the data from one environment to another environment how would you manage the connections?
What is different between the data warehouse and data mart?
Quickly characterize reusable change?
When do you use sql override in a lookup transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Which means the first record should come as last record and last record should come as first record and load into the target file?
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
What is rank transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
pmscmd startworkflow -sv
What is meant by active and passive transformation?
What is workflow? What are the components of workflow manager?
What is xml source qualifier transformation in informatica?