Hi,
I am pretty new to cloveretl. Trying to read and do some exercises and learn. I have a dbInputTable component where I have a SQL for that.
SELECT
$PARENT_SITE_KEY:= parent_site_key,
$SITE_KEY:= site_key,
$TOP_IND:= top_ind,
$BOTTOM_IND:= bottom_ind,
$RS_PRD_ID:= rs_prd_id
FROM (
SELECT
CASE p.prd_rel_type when 3 THEN p.parent_id else p.prd_id end as parent_site_key,
p.prd_id AS site_key,
CASE p.prd_rel_type WHEN 3 THEN 0 ELSE 1 END as top_ind,
CASE p.prd_rel_type WHEN 2 THEN 0 ELSE 1 END as bottom_ind,
p.prd_id AS rs_prd_id
FROM
${prm_SRC_SCHEMA}.p_prd p
LEFT JOIN
${prm_TGT_DB}.d_site s ON s.rs_prd_id = CASE p.prd_rel_type when 3 THEN p.parent_id else p.prd_id end
LEFT JOIN
${prm_SRC_SCHEMA}.p_prd p
LEFT JOIN
${prm_TGT_DB}.d_site s on s.rs_prd_id = p.prd_id
)
When I validate this, I am getting missing keyword error and I dont have the credentials to the db. So I am not able to connect to the db from TOAD or pl/sql and execute this SQL.
So pls help me in finding out what I am missing.
Thanks,
I am pretty new to cloveretl. Trying to read and do some exercises and learn. I have a dbInputTable component where I have a SQL for that.
SELECT
$PARENT_SITE_KEY:= parent_site_key,
$SITE_KEY:= site_key,
$TOP_IND:= top_ind,
$BOTTOM_IND:= bottom_ind,
$RS_PRD_ID:= rs_prd_id
FROM (
SELECT
CASE p.prd_rel_type when 3 THEN p.parent_id else p.prd_id end as parent_site_key,
p.prd_id AS site_key,
CASE p.prd_rel_type WHEN 3 THEN 0 ELSE 1 END as top_ind,
CASE p.prd_rel_type WHEN 2 THEN 0 ELSE 1 END as bottom_ind,
p.prd_id AS rs_prd_id
FROM
${prm_SRC_SCHEMA}.p_prd p
LEFT JOIN
${prm_TGT_DB}.d_site s ON s.rs_prd_id = CASE p.prd_rel_type when 3 THEN p.parent_id else p.prd_id end
LEFT JOIN
${prm_SRC_SCHEMA}.p_prd p
LEFT JOIN
${prm_TGT_DB}.d_site s on s.rs_prd_id = p.prd_id
)
When I validate this, I am getting missing keyword error and I dont have the credentials to the db. So I am not able to connect to the db from TOAD or pl/sql and execute this SQL.
So pls help me in finding out what I am missing.
Thanks,
Please sign in to leave a comment.
Comments 1