Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I got a strange issue. I have created a simple job to load the data to Redshift Target Table. When i run this job, in Logs it shows me that is getting inserted, But actually the data is NOT getting inserted in Database. Is there any issue with JOB settings?
I checked the window after the job runs and it shows all the data correctly. This is the 1st time I am loading data in REDSHIFT tables after database has been setup. What could be possible reason?
@sushantk19, before tMsSqlserverInput (tDBInput) component use tRedshiftconnection and connect using on component ok from tRedshiftconnection to tMsSqlserverInput (tDBInput) and in the tRedshiftOutput enable the check box of Use an existing connection.
now it is working as i reduced the commit every "rows" from Advanced settings. I was suggested to use the "Auto commit" option. But to do that, I have to use tRedshift connection component. I tried connecting that to my existing job, but it is throwing an error. Can you share if possible how to connect this tRedshift connectioncomponent with tRedshiftoutput component?
ok. I have a different scenario. My source is like a SQL server and target is REDSHIFT table. Please see the screenshot attached.Please suggest where and how do i connect tRedshift connection component.
@sushantk19, before tMsSqlserverInput (tDBInput) component use tRedshiftconnection and connect using on component ok from tRedshiftconnection to tMsSqlserverInput (tDBInput) and in the tRedshiftOutput enable the check box of Use an existing connection.
Works perfectly fine, but the performance is slower as compared to earlier run where commit interval was changed at the tRedshiftoutput component.
Initially the job used to take ~5 mins to load 10000 records with commit every 10000 rows. Now with this component connected it has taken ~ 17 mins. Is there issue using this approach?