apex-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mukkamula, Suryavamshivardhan (CWM-NR)" <suryavamshivardhan.mukkam...@rbc.com>
Subject RE: Information Needed
Date Mon, 16 May 2016 20:20:47 GMT
Hi Ashwin,

It is to get all the 10k rows as a single batch and process them and insert into destination
database.

Which one is suggested ,  to get single row from database or batch of 10k rows and process
and then insert into destination database?

Regards,
Surya Vamshi

From: Ashwin Chandra Putta [mailto:ashwinchandrap@gmail.com]
Sent: 2016, May, 16 1:50 PM
To: users@apex.incubator.apache.org
Subject: Re: Information Needed

Surya,

By single row tuple, are you looking for a way to enrich/join your tuples with a single tuple
from another table? Or simply get all rows from the origin database table as a single batch
of 10000 tuples?

Regards,
Ashwin.

On Mon, May 16, 2016 at 8:54 AM, Mukkamula, Suryavamshivardhan (CWM-NR) <suryavamshivardhan.mukkamula@rbc.com<mailto:suryavamshivardhan.mukkamula@rbc.com>>
wrote:
Hello Team,

Use Case : Batch ingestion of transaction data (rows = 10000) from DB2 to Vertica database.

Question : How Can I make DB2 Connection in such a way that I get a single row tuple only
? Do you have any sample code which reads from one database and writes into another database
?

Regards,
Surya Vamshi


_______________________________________________________________________

This [email] may be privileged and/or confidential, and the sender does not waive any related
rights and obligations. Any distribution, use or copying of this [email] or the information
it contains by other than an intended recipient is unauthorized. If you received this [email]
in error, please advise the sender (by return [email] or otherwise) immediately. You have
consented to receive the attached electronically at the above-noted address; please retain
a copy of this confirmation for future reference.



--

Regards,
Ashwin.
_______________________________________________________________________

This [email] may be privileged and/or confidential, and the sender does not waive any related
rights and obligations. Any distribution, use or copying of this [email] or the information
it contains by other than an intended recipient is unauthorized. If you received this [email]
in error, please advise the sender (by return [email] or otherwise) immediately. You have
consented to receive the attached electronically at the above-noted address; please retain
a copy of this confirmation for future reference.
Mime
View raw message