DSXchange

You could load this into a hash file and look it up instead of doing this on every row.

How can I do the lookup in the INPUT stage? I only know how to do lookup from a TRANSFORM stage. Any help is appreciated.

Thanks.

In my INPUT Stage, I need to select data from a table all rows that are loaded in the current month. I have a separate date control table where I have a row for each month. The max date on the date control table gives the current month capture date. ie. SELECT ... FROM FACT WHERE CAPTR_DT = (SELECT ...

Thanks, Keith & Craig, for clarifying.

Jen

If you want A to finish before B starts, you should break this up into two discrete steps. For example, landing the data to a flat file would allow the 'select' to finish before you would then pick up the flat file and load it. There may be other options specific to Teradata stages, but since I'm n...

I'm working with Teradata plug-in stages, but I think the question applies to all databases. I have a job executing an SQL that joins table A & B, do necesssary transform, and produce an output to insert back into table B through a database load. My job was hung, and database trace shows the loa...

Thanks Keith. It's asking for the file name for each output link. I suppose I can specify the same file name in each case?

Thanks.
Jen

Hi, Is it possible to perform lookup against the same hash file using multiple input columns within a single transform? I have a sequential file input with 2 amount fields and 2 different currency codes, and need to perform currency conversion. The hash file has the currency code, and the conversion...