Search found 3 matches
- Wed Sep 28, 2011 10:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector load using Bulk mode
- Replies: 7
- Views: 7878
Teradata Connector load using Bulk mode
Hi, I am trying to load to Teradata using TD Connector Stage. Job Design DataSet----Transformer----TD Connector(Access Method - Bulk and Load type - Load) Job is failing with error Error tables are invalid OR <tablename> is in an invalid state for Load Main table is one database and error and log ta...
- Tue Oct 19, 2010 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding rows to a single column
- Replies: 8
- Views: 5565
- Mon Oct 18, 2010 11:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding rows to a single column
- Replies: 8
- Views: 5565
Adding rows to a single column
Hi I have a scenario below, plz help me with the solution. Input ------- Key Add 1 3456 ABC lane 1 Apt 544 1 Charlotte NC 1 28217 2 101 ABC lane 2 Apt 467 2 Dallas Texas 2 75252 Output ----------- Key Add 1 3456 ABC lane, Apt 544, Charlotte NC, 28217 2 101 ABC lane, Apt 467, Dallas Texas, 75252 Than...