Create a mapping table joining two mapping loads from 2 qvds

[julioarriaga]

Is it possible and correct to create a mapping table joining two mapping loads from 2 qvds?

Thanks!

SociosPostuladosID:
MAPPING LOAD DISTINCT ID AS %Key_Vacante
FROM [$(pRuta)$(pDatosBaseHechos)$(Hechos)Vacantes.qvd] (QVD);

JOIN (SociosPostuladosID)
MAPPING LOAD DISTINCT ID_VACANTE AS %Key_Vacante
,EMPLID AS %Key_SocPostID
FROM [$(pRuta)$(pDatosBaseDim)RegistroCandidato.qvd] (QVD);

[sunny_talwar · Accepted solution]

I don't think this is possible... may be join first and then create a mapping load within the resident load

SociosPostuladosID:

LOAD DISTINCT ID AS %Key_Vacante

FROM [$(pRuta)$(pDatosBaseHechos)$(Hechos)Vacantes.qvd] (QVD);

JOIN (SociosPostuladosID)

LOAD DISTINCT ID_VACANTE AS %Key_Vacante

,EMPLID AS %Key_SocPostID

FROM [$(pRuta)$(pDatosBaseDim)RegistroCandidato.qvd] (QVD);

MappingSociosPostuladosID:

MAPPING

LOAD *

Resident SociosPostuladosID;

DROP Table SociosPostuladosID;