This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi Team,
Could you please suggest why Redshift bulk load have high input time and how can we solve this issue.
We are fetching data from SQL Server and inserting into redshift.
Source records count : 59473885
Please refer to Pipeline execution stati...
I have a script snap that I’m using to do some weird data manipulation to amalgamate 3-hourly data and 1-hourly data into a consistent 1-hourly format. Here is my script, I’m using javascript code:
// Ensure compatibility with both JDK 7 and 8 JSR-22...
I’ve done a join to 5 tables. All works fine in validation. No errors at all. If I use a specific value in the where clause in the 4 SQL Selects, it’ll run fine. If I give it a parameter (instead of a hardcoded value). I get the error “Not Comparable...
I have a REST API that returns something like the following:
entity":
{
“items”:
[
{
“tableName”:
“mytable”
“count”:
7995
“columnNames”:
[
“c1”,“c2”,“c3”,“c4”
]
“rows”:
[
[r1c1value,r1c2value,r1c3value,r1c4value],[r2c1value,r2c2value,r2c3value,r2c4va...
Hi Good day,
I have a requirement where I need to place four source csv files in a location . Instead of using the csv formatter and file reader four times , do we have a method of combining all the four csv files and place it in a location . Here ea...
I am building a large data extract and have to run many API calls and then output them to CSV files. Is there a way I can run a whole bunch of those rest calls and then output them to randomly named files.
Thanks for your help.
I need to read the plant-code which is either part of the source file-name or folder-name that is read via SFTP and then generate an output file with the same plant-code as part of the target file-name. How can I do that?
The second part of the same ...
