Thanks UCDI.. We bought information analyzer and we are in the process of installing and configuring but it will take some time before we fully utilize IA.
Besides IA, anyone has any other ideas? Does DataStage has the feature to analyze data and determine the data types for flat file sources?
Search found 35 matches
- Fri Oct 13, 2017 7:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Automate loading flat files
- Replies: 8
- Views: 4205
- Wed Oct 11, 2017 10:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Automate loading flat files
- Replies: 8
- Views: 4205
chulett, it's census data (age, race, ethnicity, education level, etc..) for continental US and the data is spread over in 90 files.. There is a tool called Aginity (SQL query tool for Netezza), which analyzes the data and comes up proper table definitions and then creates the table on the fly. Unfo...
- Wed Oct 11, 2017 10:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Automate loading flat files
- Replies: 8
- Views: 4205
- Wed Oct 11, 2017 7:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Automate loading flat files
- Replies: 8
- Views: 4205
Automate loading flat files
Hi all, Recently we are getting requests to load hundreds of flat files into our Netezza database using DataStage. I have used RCP feature for SQL Server and Oracle sources and that DataStage in those cases automatically generated and created the tables on the fly in target Netezza. However, for fla...
- Mon Feb 13, 2017 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Apostrophe value in the data
- Replies: 3
- Views: 2937
Re: Apostrophe value in the data
Changing the data type in SQL server ODBC stage from 'varchar' to 'nvarchar' fixed the problem.
- Sat Nov 15, 2014 8:44 am
- Forum: General
- Topic: Switching Data Centers - Challenges
- Replies: 9
- Views: 3965
- Fri Nov 14, 2014 10:01 am
- Forum: General
- Topic: Switching Data Centers - Challenges
- Replies: 9
- Views: 3965
Thanks all for the positive replies... Its very encouraging... I will make sure that host names are unchanged in the host files... BUT IP addresses in the host files will definitely change. I believe the host names are embedded in the product, not the IP addresses. But please feel free to correct me...
- Thu Nov 13, 2014 7:27 pm
- Forum: General
- Topic: Switching Data Centers - Challenges
- Replies: 9
- Views: 3965
Switching Data Centers - Challenges
Hi all, We are in the process of switching our data centers for better service. We are currently on DataStage 8.1 as of FP1, UNIX - Server Edition. Our topology: Engine tier, Metadata repository tier (Oracle) resides on host 'DVETL1' Websphere App Server resides on host 'DVETL2' Our new data center ...
- Thu Aug 07, 2014 9:07 am
- Forum: General
- Topic: DataStage Designer Connection Issues (81002)
- Replies: 7
- Views: 4254
- Wed Aug 06, 2014 9:16 am
- Forum: General
- Topic: DataStage Designer Connection Issues (81002)
- Replies: 7
- Views: 4254
Re: DataStage Designer Connection Issues (81002)
That makes sense why director isn't disconnecting... but I am still perplexed about the designer client...
Thanks..
Thanks..
- Wed Aug 06, 2014 8:28 am
- Forum: General
- Topic: Error Calling Subroutine in DataStage Director
- Replies: 12
- Views: 18183
- Wed Aug 06, 2014 8:27 am
- Forum: General
- Topic: DataStage Designer Connection Issues (81002)
- Replies: 7
- Views: 4254
DataStage Designer Connection Issues (81002)
Hi all, We are repeatedly getting "The connection is broken (81002)" error messages when the designer client is left idle for 2 or 3 minutes. There is no issue with director client. Timeout settings in administrator and global timeout settings (web) seems to be fine and nothing has changed...
- Tue Aug 05, 2014 12:54 pm
- Forum: General
- Topic: Error Calling Subroutine in DataStage Director
- Replies: 12
- Views: 18183
- Tue May 20, 2014 2:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Refresh Environments - Issue related to hashed files
- Replies: 10
- Views: 7183
ArndW, Both test and prod are DataStage 8.1 and they are as of fix pack 1. Ray, There are no compiler errors. It's just that the same exact job design compiled on two different servers works differently. If I copy the executable from PROD to TEST, then ETL works fine. The executable generated on TES...
- Mon May 19, 2014 9:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Refresh Environments - Issue related to hashed files
- Replies: 10
- Views: 7183