Key value for hash file
Posted: Tue Feb 08, 2005 11:15 am
Hi
I have 2 questions for everyone.
1. I am trying to do a join on data coming from a oracle table with another oracle table using the hash file and transformer stages. The key column in hash file, is it like the primary key in database or is it used just to do a join with other columns from a different table in transformer stage. What if the key column has same values across all records. What the key column in hash file do in such a case.
oracle
|
V
hash file
|
V
Transformer(join here)----->oracle
^
|
Oracle
2. I am using user defined sql in the Oracle stage to get my values. I need sysdate to be populated into a target table. I am having a lot of difficulty trying to convert and load a sysdate and another field with date in dd/mm/yyyy format to orace format. What sql datatype would you use in the oracle stage to convert the sysdate into a suitable format that can be loaded into another oracle stage. I have tried different combinations of datatypes (char,date,timestamp)and sql functions like to_char,to_date to make this work but the database is still erroring out my records.
In what cases would you use date, timestamp, char or time.
Please inform
Thanks
Babu
I have 2 questions for everyone.
1. I am trying to do a join on data coming from a oracle table with another oracle table using the hash file and transformer stages. The key column in hash file, is it like the primary key in database or is it used just to do a join with other columns from a different table in transformer stage. What if the key column has same values across all records. What the key column in hash file do in such a case.
oracle
|
V
hash file
|
V
Transformer(join here)----->oracle
^
|
Oracle
2. I am using user defined sql in the Oracle stage to get my values. I need sysdate to be populated into a target table. I am having a lot of difficulty trying to convert and load a sysdate and another field with date in dd/mm/yyyy format to orace format. What sql datatype would you use in the oracle stage to convert the sysdate into a suitable format that can be loaded into another oracle stage. I have tried different combinations of datatypes (char,date,timestamp)and sql functions like to_char,to_date to make this work but the database is still erroring out my records.
In what cases would you use date, timestamp, char or time.
Please inform
Thanks
Babu