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
- 10589 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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Can we create two repositories on same database instance in oracle?
Explain lookup transformation in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the Process to creating lookup transformation in informatica
What is resilience time?
What are the reusable transformations?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are mapplets?
What if the source is a flat-file?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by target load plan?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Is it possible to define a single node as a Gateway node as well as worker node?
What is informatica? Why do we need it?
