Where Exist function when loading two different Sources full loads before creating QVD's

[chandu441]

Hi QV World,

Help me in the below scenario if anyone can....

I am having two tables which Table 'A' is loading from DWH and Table 'B' is loading from SAP BW..

Both are full loads daily when it is reloading....

Thing is I need to load the records of Table 'B' with the exist function of a field from Table 'A'.

because if i load Table 'B' whole table then it is taking 4 hours minimum in QMC. So i need to restrict the records with this Table 'B' Field while loading Table 'B'.

Any help from anyone is appreciated...

Thanks

Satya

[tresesco]

May be like:

Load

          Field1

From TableA;

Load

          Field2

From TableB where exists (Field1, Field2);

[chandu441]

Hi Tresesco,

The source loading data is from DWH and SAP BW not from QVD's..... so using QV functions we can't load the SAP BW Source tables.