Skip to Content
0
Former Member
Nov 05, 2014 at 10:11 AM

Time out Issues with FM Based Extractor

50 Views

Hi All,

Requirement is to get the request details from more than one table and join conditions are not 1-1. It requires some text to be appended to join another table and need to lookup log tables to fetch few details.

Ex: Table A:

Reqno

Created_at

ReqType

1

11/12/2012

23

2

10/18/2013

28

3

11/15/2013

29

4

4/3/2014

23

Table B:

Instanceno

Updated_at

Status

/ABC/1

13/12/2012

RUNNING

/ABC/2

11/18/2013

FINISHED

/ABC/3

12/15/2013

RUNNING

/ABC/4

4/12/2014

FINISHED

To join A and B, We need to append ‘/ABC/’ to the reqno to get the Instanceno.

To get the above requirement created a FM Based extractor.

Input to the Extractor is View. This has 180 thousands of records. As a part of the requirement we need to lookup log table, which has 838 thousands of records.

When I am running the Extractor in RSA3, I am getting Time out error for below select statement.

Log Table structure: Table C

Reqno

updated_on

prov_item_id

1

11/12/2012

2

2

10/18/2013

4

3

11/15/2013

2

4

4/3/2014

4

SELECT reqno updated_on prov_item_id
FROM C INTO TABLE it_c
FOR ALL ENTRIES IN A
WHERE reqno = A-reqno.

When I am running the Full IP on BW side, it is running for long time like 1.5 hrs to fetch 7,500 records.

Log Table is not indexed one. So planning to make it indexed one.

Need your valuable suggestions to fetch the data fast in BW side.