DSXchange

Thanks for your reply. DataStage job is not populating the "results" key word. As per IBM support note - the "results" key is being populated for JSON format binding. Is there an option to drop/uncheck the "results" header in the Information Services Directory client?

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.

I can only read the first row from the file. 2nd row is rejected while reading as the column data is continued in the next line.

I think the tool is assuming the column has been ended without proper delimiter as it goes all the way to the end of the file and skipping the row.

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...

It worked. Thanks a lot Ray. You made it easier.

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...

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...