Search found 3 matches

by mehimadri_123
Thu May 02, 2019 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mismatch in data read in DB2 AS400 using SQL client and DS
Replies: 2
Views: 2666

Mismatch in data read in DB2 AS400 using SQL client and DS

Hello Everyone, I am reading a DB2 AS400 Table using DataStage (v11.7) DB2 Connector Stage and writing it out to a peek stage (will finally write it off to a flat file on S3). Now, while all the other tables that I have read so far, I could verify that the data was loaded correctly from DB2 to targe...
by mehimadri_123
Thu Apr 18, 2019 10:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: S3 connector error with transferring large files
Replies: 0
Views: 2576

S3 connector error with transferring large files

Hello Everyone, We have a parallel Job reading DB2 AS400 table and writing out to AWS S3 bucket. Now, while this Job is working for all other relatively smaller tables, but for one large table with 200 million records and of size around 50 GB it is failing after few hours with the following error. W...
by mehimadri_123
Wed Nov 01, 2017 11:06 am
Forum: General
Topic: Loading Excel into Hortonworks
Replies: 1
Views: 2297

Loading Excel into Hortonworks

Hello Friends,

Can anyone done this and let me know how to load an excel file into Hortonworks?

Thanks!