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
- 9701 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
Can we get 1st record through Informatica(without sequence number).
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain load alternative records / rows into multiple targets - informatica
Which development components of informatica have the highest usage?
What is standalone command task?
Under what condition selecting sorted input in aggregator may fail the session?
Why sorter is an active transformation?
What is dynamic cache?
Which transformation is needed while using the Cobol sources as source definitions?
Performance tuning( what you did in performance tuning)
What is aggregator transformation in informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is domain in terms of informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the aggregator transformation?
