Sambadu Posted November 5, 2015 Report Posted November 5, 2015 u hv to instert bulk data .. right? creating constaints/keys on new tables??
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 business hrs lo run chestara?? downtown time alantivi unaya? Business hrs ne baa
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 Data takkuve kaani pichikari fail aithe .. Aa tables vere process kuda use sesthadi... u hv to instert bulk data .. right? creating constaints/keys on new tables??
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 Scheduler vadu man. Commits rasi padeyyi to all tables. Call all of them simultaneously If any load fails, truncate tables job run cheyi Truncate too much ante delete mathram cheyi. Performance fail kakunda undali ante stats collection compulsory vere process kuda run avuthu untayi aa tables use cheskoni.. so data chunks la process seyali.. temp table lo load chesi cheyocha
electionszindabad Posted November 5, 2015 Report Posted November 5, 2015 Transactions lo inserts statements pettu. Locking hints kuda add cheyyi
andhravodu Posted November 5, 2015 Report Posted November 5, 2015 vere process kuda run avuthu untayi aa tables use cheskoni.. so data chunks la process seyali.. temp table lo load chesi cheyocha cheyochu. basic ga nuvvu partition tables petti, partition exchange cheyatam correct ee situation ki partition exchange job last step and will be called only after successful completion of all load jobs
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 cheyochu. basic ga nuvvu partition tables petti, partition exchange cheyatam correct ee situation ki partition exchange job last step and will be called only after successful completion of all load jobs try sestha guruvu garu
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 Transactions lo inserts statements pettu. Locking hints kuda add cheyyi Locking hints kastha explain seyya vuu
JollyBoy Posted November 5, 2015 Report Posted November 5, 2015 SSIS check points use cheyachu. in sql server
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 SSIS check points use cheyachu. in sql server 8 tables ki okesari load cheyadaniki vadocha check points all 8 tables primary keys unna tables
JollyBoy Posted November 5, 2015 Report Posted November 5, 2015 8 tables ki okesari load cheyadaniki vadocha check points all 8 tables primary keys unna tables ela aina vaduckochu.. main table first load chey.. based on FK next table chudu
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 ela aina vaduckochu.. main table first load chey.. based on FK next table chudu main table success ayyi vere process aa main table ni vadukuntu second table load ayye time lo fail aithe process appudu back track ela how how ?
JollyBoy Posted November 5, 2015 Report Posted November 5, 2015 main table success ayyi vere process aa main table ni vadukuntu second table load ayye time lo fail aithe process appudu back track ela how how ? are you using the first table to load the second.. or just referring FK. FK aite you dont need to track .. check point will do
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 are you using the first table to load the second.. or just referring FK. FK aite you dont need to track .. check point will do gotcha..
kirs149 Posted November 5, 2015 Author Report Posted November 5, 2015 Scheduler vadu man. Commits rasi padeyyi to all tables. Call all of them simultaneously If any load fails, truncate tables job run cheyi Truncate too much ante delete mathram cheyi. Performance fail kakunda undali ante stats collection compulsory Pacets system idea unda baa neeku
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts