Left Join Stuck

[risabhroy_03]

I am joining my table as below - 

[TEST]:
Load
"T$ITEM" & '|' & "T$STBP" & '|' & Company_Code as [Temp_Key_Item],
"T$STBP" as [Customer],
"T$CTEM" as [Customer Part],
"T$ITEM" as [Internal Part]

FROM [$(vSource)\TCISLI245.qvd](qvd);

Left Join([TEST])

Load
"T$ITEM" & '|' & "T$BPID" & '|' & Company_Code as [Temp_Key_Q],
"T$TRDT" as [TRDT],
"T$QSTK" as [Quantity_WHINR110]

FROM [$(vSource)\TWHINR110.qvd](qvd)
where ("T$KOOR"=3 or "T$KOOR"=7) and ("T$KOST"=5);

Exit Script;

But it stucks here - 

I left this for hours but it is stuck here.

[PrashantSangle]

Hi,

Using which key field you are doing joining?

I don't see common field between those table.

If you are trying to join using those key field, then the name of the key field must be same in both table

Regards,

[risabhroy_03]

Ohh sorry,

kindly consider this - 

[TEST]:
Load
"T$ITEM" & '|' & "T$STBP" & '|' & Company_Code as [Temp_Key_Q],
"T$STBP" as [Customer],
"T$CTEM" as [Customer Part],
"T$ITEM" as [Internal Part]

FROM [$(vSource)\TCISLI245.qvd](qvd);

Left Join([TEST])

Load
"T$ITEM" & '|' & "T$BPID" & '|' & Company_Code as [Temp_Key_Q],
"T$TRDT" as [TRDT],
"T$QSTK" as [Quantity_WHINR110]

FROM [$(vSource)\TWHINR110.qvd](qvd)
where ("T$KOOR"=3 or "T$KOOR"=7) and ("T$KOST"=5);

Exit Script;

[PrashantSangle]

Well I don't see any error in this script .

now to debug the issue Instead of full load try with limit load. 

Regards

[risabhroy_03]

Debug is running perfect with limit load.

[PrashantSangle]

Then I don't think so anymore I can assist you resolve the error. 

Just try with increasing values of limit load and then do full load at that time check you cpu utilisation.

This is only reason which come in my mind.