Migrating AbInitio Lookup_count () functionality into talend

Anonymous — Fri, 25 Oct 2013 12:20:30 GMT

Hi , i am working in AbInitio to Talend migration PoC, i am finding dificulty to Migrating AbInitio Lookup_count() functionality to talend . Please help me to do this in talend.
let integer(8) parent_count=lookup_count("Lookup - DSMT_MAN_SEG_HIER- {CHILD_NODE_ID}", in.CHILD_NODE_ID,"A");
let integer(4) is_valid_unique_parent = (parent_count<=1);
let integer(4) is_valid_effdt = is_defined(in.EFFDT) && (string_trim(in.EFFDT)!="");
let integer(4) is_valid_eff_status = is_defined(in.EFF_STATUS) && (string_trim(in.EFF_STATUS)!="");

if ( is_valid_parentnode_in_man_seg && is_valid_childnode_in_man_seg && is_valid_unique_parent && !(is_null(is_valid_effdt) || !is_valid_effdt) && (!(is_null(is_valid_eff_status) || !is_valid_eff_status) || ( is_defined(in.EFF_STATUS) && (string_trim(in.EFF_STATUS)!="I"))) )
begin
valdn_rslt ="Valid";
end

Re: Migrating AbInitio Lookup_count () functionality into talend

Anonymous — Tue, 29 Oct 2013 07:57:55 GMT

Hi
I am not family with AbInitio Lookup_count() function, it seems you need to re-write this function in Java by creating a new routine in Talend.

Re: Migrating AbInitio Lookup_count () functionality into talend

Anonymous — Wed, 10 Dec 2014 15:52:34 GMT

Thanks for the comments

topic Migrating AbInitio Lookup_count () functionality into talend in Talend Studio

Migrating AbInitio Lookup_count () functionality into talend

Re: Migrating AbInitio Lookup_count () functionality into talend

Re: Migrating AbInitio Lookup_count () functionality into talend