Posted: Wed Jun 18, 2008 8:39 am
Could you add a peek of all rows between remove duplicates and lookup and manually check row 2257 +- 1?
A short text to describe your forum
http://dsxchange.com./
I know that Peek stage gets data from an input (in this case, the rem dup stage) ... but....can output this same data to the lookup?ArndW wrote:Could you add a peek of all rows between remove duplicates and lookup and manually check row 2257 +- 1?
OK, I did it myself. I put a Peek stage between RemDup and Lookup stage, but I did not get too much help.manuel.gomez wrote:I know that Peek stage gets data from an input (in this case, the rem dup stage) ... but....can output this same data to the lookup?ArndW wrote:Could you add a peek of all rows between remove duplicates and lookup and manually check row 2257 +- 1?
How shall I check those records manually? in the peek? how?
Thanks a lot
It gave me this, but I dont know if I am getting row 2257, it does not seem to be correctAll records = False
Number of records = 3
Period = 2256
Peek_50,0: REF_OFERTA:10 CIF:A08829699 COD_GESTOR:mruizji COD_EST_OF:AC IN_ANEXOS:NO EST_PRO:NO
Peek_50,0: REF_OFERTA:12880 CIF:Q2800540C COD_GESTOR:acalvo1 COD_EST_OF:AC IN_ANEXOS:NO EST_PRO:NO
Peek_50,0: REF_OFERTA:15076 CIF:B38480752 COD_GESTOR:rperezd6 COD_EST_OF:AC IN_ANEXOS:NO EST_PRO:NO
use a copy stage between remove duplicate and lookup and from copy stage pass it to peek(to anlyze that in log)/sequential file/dataset where you want to analyze tha data.manuel.gomez wrote:I know that Peek stage gets data from an input (in this case, the rem dup stage) ... but....can output this same data to the lookup?ArndW wrote:Could you add a peek of all rows between remove duplicates and lookup and manually check row 2257 +- 1?
How shall I check those records manually? in the peek? how?
Thanks a lot
uuuupssss........it seems you found the problem......priyadarshikunal wrote:1 more thing check the keys defined in remove duplicate and lookup i hope both are same
returns 9851 rows ,SELECT G.REF_OFERTA , R.COD_GR_EMP
FROM
REL_GR_EMP_EMP R, GRUPOS_EMPRESARIALES GR
COFER_LISTA_CIFS C, COFER_DATOS_GRAL G,
WHERE
R.COD_GR_EMP = GR.COD_GR_EMP AND
R.CIF = C.CIF AND
C.REF_OFERTA = G.REF_OFERTA AND
G.COD_EST_OF='AC'
For me, they are doing the same (but they obviously dont, as I dont get same results)SELECT A.COD_GR_EMP
FROM
(SELECT
REL_GR_EMP_EMP.COD_GR_EMP,
REL_GR_EMP_EMP.CIF
FROM
dbo.GRUPOS_EMPRESARIALES AS GRUPOS_EMPRESARIALES
INNER JOIN
dbo.REL_GR_EMP_EMP AS REL_GR_EMP_EMP
ON GRUPOS_EMPRESARIALES.COD_GR_EMP = REL_GR_EMP_EMP.COD_GR_EMP
GROUP BY
REL_GR_EMP_EMP.COD_GR_EMP,
REL_GR_EMP_EMP.CIF ) A ,
(SELECT COFER_LISTA_CIFS.CIF
FROM
dbo.COFER_DATOS_GRAL AS COFER_DATOS_GRAL
INNER JOIN
dbo.COFER_LISTA_CIFS AS COFER_LISTA_CIFS
ON COFER_DATOS_GRAL.REF_OFERTA = COFER_LISTA_CIFS.REF_OFERTA
WHERE COFER_DATOS_GRAL.COD_EST_OF = 'AC'
GROUP BY COFER_LISTA_CIFS.CIF ) B
WHERE A.CIF = B.CIF
as we don't know the keys and the relationship between all the tables used in the query, i am unable to answer.manuel.gomez wrote:uuuupssss........it seems you found the problem......priyadarshikunal wrote:1 more thing check the keys defined in remove duplicate and lookup i hope both are same
Anyway, this fixes the warning in the lookup stage, but still I cant get desired results
This just became a sql query issue, you may help me, because I must be missing something really stupid
How is it possible this query:returns 9851 rows ,SELECT G.REF_OFERTA , R.COD_GR_EMP
FROM
REL_GR_EMP_EMP R, GRUPOS_EMPRESARIALES GR
COFER_LISTA_CIFS C, COFER_DATOS_GRAL G,
WHERE
R.COD_GR_EMP = GR.COD_GR_EMP AND
R.CIF = C.CIF AND
C.REF_OFERTA = G.REF_OFERTA AND
G.COD_EST_OF='AC'
and this one only 9785:
For me, they are doing the same (but they obviously dont, as I dont get same results)SELECT A.COD_GR_EMP
FROM
(SELECT
REL_GR_EMP_EMP.COD_GR_EMP,
REL_GR_EMP_EMP.CIF
FROM
dbo.GRUPOS_EMPRESARIALES AS GRUPOS_EMPRESARIALES
INNER JOIN
dbo.REL_GR_EMP_EMP AS REL_GR_EMP_EMP
ON GRUPOS_EMPRESARIALES.COD_GR_EMP = REL_GR_EMP_EMP.COD_GR_EMP
GROUP BY
REL_GR_EMP_EMP.COD_GR_EMP,
REL_GR_EMP_EMP.CIF ) A ,
(SELECT COFER_LISTA_CIFS.CIF
FROM
dbo.COFER_DATOS_GRAL AS COFER_DATOS_GRAL
INNER JOIN
dbo.COFER_LISTA_CIFS AS COFER_LISTA_CIFS
ON COFER_DATOS_GRAL.REF_OFERTA = COFER_LISTA_CIFS.REF_OFERTA
WHERE COFER_DATOS_GRAL.COD_EST_OF = 'AC'
GROUP BY COFER_LISTA_CIFS.CIF ) B
WHERE A.CIF = B.CIF
Thanks for your help!!!!