1) Alternative to update strategy transformation 2) out of 1000 records after

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

Question Posted / palthepu_santosh

3 Answers
9696 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records..

Answer / raju4dw

U CAN GO FOR SESSION RECOVERY

THEN IT WILL LOADS ONLY REMAING RECORDS INSTEAD OF ALL
RECORDS.

RAJENDRA

Is This Answer Correct ?

7 Yes

0 No

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records..

Answer / mike

1)YOu can update the target table by using target update
override. I think this might be the alternative

2)consider performance recovery

3)lookup override is nothing but overriding the default sql
which is generated by the lookup at run time. the default
sql contains select,groupby and orderby clauses. The
orderby clause orders the data based on the ports in lookup
tab. If you want to change the order then we need to
mention two hyphens at the end of the sql, which means the
query generated by the informatica server is commented.

correct me if i was wrong

Is This Answer Correct ?

6 Yes

0 No

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records..

Answer / 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