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
- 10407 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
How do you load first and last records into target table?
What is Index Caches size?
Which are the different editions of informatica powercenter that are available?
Sequence generator, when you move from develoment to production how will you reset
How to join three sources using joiner? Explain though mapping flow.
What is workflow monitor?
What is different between the data warehouse and data mart?
How many numbers of sessions can one group in batches?
How to create or import flat file definition in to the warehouse designer?
Explain what are the different versions of informatica?
What is a router transformation?
Explain lookup transformation in informatica
How to go to the older version for a mapping?
what is size of u r database?
What is the reusable transformation?
