Interested to Buy Any Domain ? << Click Here >> for more details...
1) Alternative to update strategy transformation
2) out of 1000 records after loading 200 records, the
session got failed. how do u load the rest of records ??
3) use of lookup override
- 3 Answers
- 10538 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pradeep
1)Alternative to updated strategy,we can with target update override. US works based primaray key constrainst where as target updated override works without primary key constraints.
2)When you configure session with Normal load,the integration service performs record by record as a result IS can capture commit points and it enables the session recovery.
The IS capture commits points from database log and saves in repository
3) The lookup transformation genrates the sql qurey,query contains select,group by,order by.we can override default query by specifying the order by clause
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is Session and Batches?
Global and Local shortcuts. Advantages.
How does a rank transform differ from aggregator transform functions max and min?
What are the designer tools for creating transformations?
What is Index Caches size?
Where is metadata stored?
How to generate sequence numbers using expression transformation?
How to load data in informatica ?
What are the features of complex mapping?
What is sq transformation?
Explain the scenario which compels informatica server to reject files?
What does role playing dimension mean?
What is a shortcut and copy in Informatica and how two are different with each other?
What is a standalone command task?
