DSXchange

Can recursive parsing be done on a JSON file using hierarchial stage.
I believe for XML parsing we do have an option 'Recursive to List' for handling parent- child records. But in JSON parser not able to see this option though

Exact search gave 2 posts here and they didn't help

Any luck in this topic. Can we read SAS dataset(sas7bdat format)using SAS Parallel DS

There are few scenarios where our process is failing with File not found error, though file is already available in that location with proper access. When we resubmit, it will get complete without any issues. We are seeing this behavior mainly in execute command activity stage, where are taking word...

Use CAST function in your SELECT statement.

Hi, Recently we did DataStage and OS upgrade. DataStage upgraded from 8.7 to 11.5 and OS upgraded from Unix to Redhat Linux. Earlier we used istool to import and export jobs. After upgrade, not able to see "istool" in ../InformationServer/Clients/istools/cli". Instead there is one fil...

Did you check this post?

viewtopic.php?p=262449

You can generate the file in ASCII and convert it to UTF-8 using iconv command in unix.

iconv -f ascii -t utf-8 f1.txt -o f1.utf8.txt

You can, may be if you get a chance to work with Teradata enterprise stages.

Are there any primary indexes defined. Because it will highly impact the performance.

Use Bulk option with load method as LOAD. This is equivalent to Fastload utility available in teradata. It will be faster in loading huge volume of data to empty table.

Create a new column where input columns are concatenated based on your joining criteria. (ABC, DE, EFGH). Use that column as key in your JOIN.

How about multiplying the number with -1 to flip the sign wherever required.

Downloaded new driver from internet and copied *.so files to /lib directory. After that I am able to connect.

Hi Kim,
Any idea what version of ODBC driver you used to connect. Currently we are having 5.3