Search found 7 matches
- Mon Mar 23, 2020 2:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Expose DataStage job a service - JSON Format
- Replies: 3
- Views: 8310
- Sun Dec 03, 2017 6:19 pm
- Forum: General
- Topic: Difference between ETL(DataStage) and ESB(Mulesoft)
- Replies: 1
- Views: 2503
Difference between ETL(DataStage) and ESB(Mulesoft)
These days we are hearing a lot that ESB tools like Mulesoft, Oracle SOA and few others are also able to do ETL. What is the difference between DataStage and Mulesoft. As I didn't have a clear idea on ESB tools and would like to know experts opinion on these ESBs. Thanks in advance.
- Tue Jan 26, 2016 10:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read a flat file which have the column data in the next line
- Replies: 4
- Views: 6082
- Tue Jan 26, 2016 10:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read a flat file which have the column data in the next line
- Replies: 4
- Views: 6082
Read a flat file which have the column data in the next line
Hi, I am trying to read a flat file data, where it has 8 columns. and its a | delimited. 7th column has long string and which is continued in the next line and for some rows may be like 10 lines. I have to read this data and load it to an oracle table. Data in the flat file looks like this: I am usi...
- Thu Nov 12, 2015 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prefix Column Name with Column Number
- Replies: 4
- Views: 3432
- Wed Nov 11, 2015 2:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prefix Column Name with Column Number
- Replies: 4
- Views: 3432
Hi Ray, I am pulling data from a table(Souce columns names are A,B,C) and creating a file on the server using sequential file stage as a target and first line is column names. The output column names should be (01_A, 02_B, 03_C). When i try to put 01 as prefix for the columns in sequential file stag...
- Wed Nov 11, 2015 8:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prefix Column Name with Column Number
- Replies: 4
- Views: 3432
Prefix Column Name with Column Number
Hi, I have requirement to create a file with header row in the below format. [Column#]_[Column Name] . Example 01_Student_Id. I tried to put prefix as 01, 02 in the sequential file but it throws an error the name should begin with alphabetic character. Is there anyway to achieve this? Thanks in adva...