Multiple Keys join of Files
Posted: Tue Nov 15, 2005 8:30 am
Hi,
I have a requirement that i want to join 2 data files having multiple keys a primary key.
I have read posts suggesting make one file as HASH and then joining with other file but as per documentation HASH file can have only 1 column as key. So how would i achieve this?
Secondly, Whats the best practice in DS of joining multiple tables as i am using TD and the Stage for fecthing large volume is not that efficient.
What if the size of the table is quite huge then whats the best strategy of joining these kind of tables.
Thanks in advance.
I have a requirement that i want to join 2 data files having multiple keys a primary key.
I have read posts suggesting make one file as HASH and then joining with other file but as per documentation HASH file can have only 1 column as key. So how would i achieve this?
Secondly, Whats the best practice in DS of joining multiple tables as i am using TD and the Stage for fecthing large volume is not that efficient.
What if the size of the table is quite huge then whats the best strategy of joining these kind of tables.
Thanks in advance.