DSXchange

I have decided to create a table to extract the contents of the flat file and then later do a join statement instead.

Thanks for the great suggestions, I really learnt a lot from your posts.

If I state it as an ODBC DB, will the job work on a UNIX server?
Cos I need to transfer this job to a UNIX server

How do I do this JOIN, do I use one of the stages?

ArndW's suggestion will work

Assuming your lookup is called LKP, use the LKP.NOTFOUND directly in the constraint itself within the transformer, so that whatever rows are not found in the hash will be allowed to the next stage in the transformer.

Hope I made sense in that mouthful.

Yup, I thought of that already but I am trying to avoid having to create tables in the database for this purpose.

I would like to keep this within my job (if it is possible at all)

Hi, I have 2 flat files each containing one column and I would like to take these two file and output a dataset containing a unique combination of values in both these files. Eg. 2 files are "people_file.txt", "attribute_file.txt" In "people_file.txt", values are: 1) Jo...