DSXchange

Hi, In Sparse lookup we cant map the key columns in the output tab. we need to mention the where condition using keys as <local_odbc_key>=orchestrate.<lookup_stage_key>.this would be matched automatically if the read method is an autogenerated sql or table(only if the keys are matching else we need ...

hi jwiles, thanks for ur prompt reply...i have aliased the column names to match the database columns through user defined sql. i think that would do the same as a transformer or a modify stage does. but i didnt check the leading and trailing spaces as they are char datatypes..i would check that now...

suppose the three keys in my reference link are rk1,rk2,rk3 and the three keys to which i like to map in the parent link are pk1,pk2,pk3. i am using the look up type as sparse and read method as user defined sql in which i mentioned the where condition as rk1=orchestrate.pk1 AND rk2=orchestrate.pk2 ...

hi, my parent table is having about 1000 records and i am using a reference link to a table which holds millions of records.and there are 3 key fields to be matched combined.when i tried to use sparse look up i am unable to use 3 key fields combined and hence urged to use a join instead.is there any...