DSXchange

Hi All,

I am using ODBC stage as load,my target database is DB2.I need commit each 5000 rows.colud you tell me where i can set this option.

Thanks,
Raj

Is this an interview question?

Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind?

Do you mean ODBC Enterprise stage or some other ODBC stage type?

ray.wurlod wrote:Is this an interview question?

Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind?

Do you mean ODBC Enterprise stage or some other ODBC stag ...

Hi Ray,

I need to know how many rows get inserted or updated in a target table , I think ODBC stage providing this info in the log. This is very much useful for me to generating stats report. Because of this , i am using ODBC Enterprise stage. In target ODBC stage i am using Upsert Mode =Insert then update and Write Method = Upsert.

There is problem when Volume of data is more, it took nearly 3 hours for 17 million rows to load. here commit happens on each row.

Please help me how to improve the performance in ODBC EE stage.

Thanks,
Raj

No stage can report how many were actually inserted/updated. They can only report how many they sent. You can also get a count of rejects (which the Oracle Enterprise stage can do).

You don't need a stage to tell you that, the job can. Use DSGetLinkInfo() to capture the number of records sent to the stage. And you'll need to upgrade to 8.x to have any control over the Transaction Level AFAIK.

Hi,

So we can use either ODBC Stage or an Oracle Enterprise stage to load data into an Oracle Table.

Do we have any advantage of using ODBC Stage over Oracle Enterprise Stage while loading the data. Is that a good Idea to go with ODBC?

Regards,