How to define the sequence order for the link???
Posted: Sun Sep 24, 2006 8:33 pm
Dear All,
I have some problem here. Help me pls.
I want to extract the data from 3 files to same hash file using 3 ODBC link in the same stage. Means that 3 ODBC files link to one hash file in the same time.Then,before I insert the data to the hash file,I want to clean the data at every time I run the job.Cleaning should be first ODBC file link and then want to append the data from other 2 ODBC files.So what I would like to know is do we have any way to define the sequence of the link so that I can make sure the 1st ODBC load to the hash file?
Is there any idea you have?
Thanks,
I have some problem here. Help me pls.
I want to extract the data from 3 files to same hash file using 3 ODBC link in the same stage. Means that 3 ODBC files link to one hash file in the same time.Then,before I insert the data to the hash file,I want to clean the data at every time I run the job.Cleaning should be first ODBC file link and then want to append the data from other 2 ODBC files.So what I would like to know is do we have any way to define the sequence of the link so that I can make sure the 1st ODBC load to the hash file?
Is there any idea you have?
Thanks,