Hi Everyone,
I have been working with Information Analyzer today and I was researching a way to take the reference tables that I create inside of IA and use that data by ETL processes in DataStage (via lookup or join). I know that I can go to the Investigate menu and then select Table Management to export the reference tables that I create in IA as text files, but I was wondering if anyone knew of a more direct method to call these reference tables from a DataStage job. I can definitely create load processes and load the data from the extracted txt files or call the IA_DB directly via ODBC, but I thought I may be missing a more direct path. I have searched all over [i46aegde.pdf (IA Users Guide)] and the Information Analyzer Redbook, but I have not seen any example like this.
Thanks in advance for the input.
Josh
Reference Table Question
-
- Participant
- Posts: 40
- Joined: Thu Apr 17, 2008 1:52 pm
- Location: Huntsville, AL
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 40
- Joined: Thu Apr 17, 2008 1:52 pm
- Location: Huntsville, AL