Getting Started

Connection Settings

How do I update the connection settings? I want to use Authenticate As Page in the Facebook API Query and want to use Verbosity of 5, but do not know...

s3 to ftp

Hi, I want to move files from Amazon s3 to ftb using bash script command... already tried "rsync --progress -avz -e ssh s3://folder//s3://folder/ " anyone please suggest correct command for...

shedule job

How to shedule job in every 2 hour??

Double Precision

hi, I have a data "-3024.00" ,"300.22", ,30.44" chracter varying data how to change "double precision" using convert_type?? i was tried give size and precision but got a error!!! Thanks...

To identify the duplicates on key column

Hi, I have to compare the current record key column value with previous record key column value in same tale (comparison on same column). If duplicate found, i have to...

To identify the duplicates on key column

Hi, I have to compare the current record key column value with previous record key column value in same tale (comparison on same column). If duplicate found, i have to...

MongoDb mapping

Hi, I want to mapping MongoDb fields to table fields any idea? Thanks Ganesh

Reading data from S3

I have a .csv file in S3 and i want to read that file & load it into redshift table. How can i read the .csv file from S3 and...

Auto increment

Hi, Any easy way to particular field was increasing based on data loading???? Already created table fields and at the same time copy table data one to another!!! Thanks Ganesh...

MongoDB to Redshift

Hi, Using MongoDB query component to load data Redshift.... First i was try basic option gave all credentials perfect but it did't shows all database names... And changed to advanced...