DSXchange

below is the job design,you have to use one more transformer stage

Input stream ----> Lookup Stage----->Transformer stage------> Link1 and Link2(Reject)

use remove duplicate stage on key before doing the lookup that means remove duplicates in reference data.

Yes Ray you are correct. my question is "how many tokens exist in the address field"

Hi All,

how many tokens exist in the address field.

Thanks in Advance

is it possible to connect by using ODBC?

Thanks dsedi and Ray

In two places i saw stable sort option

1) in Stage>Properties>options>stable sort(true or False)

2) input tab we have to select one check box (perform sort or stable or unique)

My question is what is the difference between these two?

Regards
Mallikharjuna Reddy

Hi,

is it possible to acceess Mainframe DB2 database by using DB2 stage.if possible please explain how to do?

Thanks in advance

Thanks asorrell

But what is the use of sort stage Stabe check box in input tab

Hi All,

in sort stage for stable sort option if we select it false, is there any effect on the performance? If it effects please explain how it will effect on performance.


Thanks in Advance

syntax is wrong in where clause,check once again

Hi,

what are the steps to follow to read the sequential file in IA8.0?

if we have the tables metadata will be available with the table,if we

have the sequential file what are the steps to process metadata?

thanks in advance

How to connect SapCRM from datastage?any plug-in is required?

My requirement is to extract the data from SapCRM.


Thanks

is it posiible to use the server transformer with parallel job stages?

Thanks srimitta.