DSXchange

if source data is large and reference data is samll, then normal lookup is faster

what will be the best method to resolve my issue.
i have a file of 200000 records, for each record i need to get a value from a Teardata table(having 200000000 records).

Can anyone give me a sample of ODBC entry in ODBC.ini file in Linux for Teradata.
how Can i Import an teradata Stored Procedure

I find it straight farwords

SQFILE---->stored procedure------->file

you can pass the input column as parameter to the store procedure,and can get outputput parameter in the output stage

i didn't find any sparse or normal lookup type for Teradata Table stage. how can i pass input column in the where clause of the select query in teradat stage. "SELECT PRTY_ID, CDBOR_CIDN APP_KEY_VAL_1 FROM RTW4B_TDW_D01_Data.TR_PRTY where CDBOR_CIDN=ORCHESTRATE.APP_KEY_VAL_1" this query do...

..........................Teradata Table
..................................|
..................................|
..................................|
source file--------->Lookup stage ------------>target

my job requires lookup from teradata table for each row of source, the teradata table has 200+ millions records. how can i pass the input column name in the where clause of select statement in the teradata table. Teradata Table | | | source file--------->Lookup stage ------------>target

very much possible. you can call it at any stage

seeta wrote:Hi,


I wrote one storedprocedure I want to call that in my job.Which stage can I use to call the stored procedure into my parlleljob.Is this posible are not?

Thanks