Search found 3 matches
- Fri Jul 06, 2012 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File using wildcards
- Replies: 2
- Views: 1794
Complex Flat File using wildcards
Hi all, i'm using Complex Flat File stage to read from different .txt file so i set: - In CFF stage -- file type "File pattern" -- file name(s) "C:\bla\bla\file_*.txt" - In Environment variable -- $APT_IMPORT_PATTERN_USES_FILESET = True The job runs correctly but i need something...
- Tue Jun 07, 2011 6:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Lookup : ODBC VS SQL Performance
- Replies: 3
- Views: 1753
- Tue Jun 07, 2011 2:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Lookup : ODBC VS SQL Performance
- Replies: 3
- Views: 1753
Oracle Lookup : ODBC VS SQL Performance
Hi all, i have a transform stage with ODBC source 10 lookup tables and an ODBC destination. The Job with transform stage takes about 15 minutes to execute. Then i made a stored procedure that simply call a INSERT INTO FROM SELECT with 10 inner join and it takes about 45 seconds. I would like to unde...