I like to know what are the options available for incremental loading in Parallel version. I know the CDC is one of the option in which we can capture insert, update and delete. Please let me know the other options.
In which design we can it as reusable design?
My source is Oracle and Target is SQL Server. (total more than 87 tables)
I tried using CDC, but I can't able to do as reusable design and also I can't use RCP enabled in Target DRS or ODBC stage for my SQL Server.
Please suggest the best solution.
Best options for Incremental Loading Reusablity
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 6
- Joined: Sat Jun 18, 2011 11:18 am
- Location: Chennai,India
Ray,
I am passing insert/update(Upsert) query required for each table and Tablename as a parameter to this reusable job from Job Activity.
If the above design is possible,then
I have one doubt if i use like this and i want to invoke this load job in a Mutiinstance way at the same time.How many instance can be invoked at the same time.
-----------------------------------------
Senthilkumarr.sudarsan@target.com
I am passing insert/update(Upsert) query required for each table and Tablename as a parameter to this reusable job from Job Activity.
If the above design is possible,then
I have one doubt if i use like this and i want to invoke this load job in a Mutiinstance way at the same time.How many instance can be invoked at the same time.
-----------------------------------------
Senthilkumarr.sudarsan@target.com
senthil kumarr
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One.
Of course you can have more than one running simultaneously, but your question was specifically how many can be started at the same time.
The limit is governed entirely by the resources available on your system, and is almost certainly less than you are hoping for.
Of course you can have more than one running simultaneously, but your question was specifically how many can be started at the same time.
The limit is governed entirely by the resources available on your system, and is almost certainly less than you are hoping for.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.