Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341028136' post='1302059678'] issue em ledu maama maa daanlo stg jobs ki bulk use chestunnaru and daanlo load method :update use chesatru so adi multiload utilty ni use chestadi and core jobs lo immedaiate use cheastam so adi mamuluga load chestadi em utilities use cheyyadu .... naa question enatntey edi eppudu use cheyyali ani adugutunna anthey general ga telusukundamani... mee daanlo database entadi oracle aa [/quote] maadi Db2 ,Sybse , Informix ......veeti gurinchi edaina sare rafe chesesta aa DB ni Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341028136' post='1302059678'] issue em ledu maama maa daanlo stg jobs ki bulk use chestunnaru and daanlo load method :update use chesatru so adi multiload utilty ni use chestadi and core jobs lo immedaiate use cheastam so adi mamuluga load chestadi em utilities use cheyyadu .... naa question enatntey edi eppudu use cheyyali ani adugutunna anthey general ga telusukundamani... mee daanlo database entadi oracle aa [/quote] dsx lo idi dorikindi mama [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left][background=rgb(217, 226, 236)]1) Immediate - For Selector, Inserter... operators. Same as CLI interface/API. (No Load/Unload Utilities). [/background][/left][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left][background=rgb(217, 226, 236)]2) Bulk - For Load, Update, Stream and Export operators (i.e. fastload, multiload, tpump and fastexport respectively). [/background][/left][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left][background=rgb(217, 226, 236)]mama vaadu cheppina points clear gane vunnayi chudu[/background][/left][/size][/font][/color] Link to comment Share on other sites More sharing options...
pandemkodi Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='Silver_mani' timestamp='1341028458' post='1302059701'] dsx lo idi dorikindi mama [left][background=rgb(217, 226, 236)]1) Immediate - For Selector, Inserter... operators. Same as CLI interface/API. (No Load/Unload Utilities). [/background][/left] [left][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(217, 226, 236)]2) Bulk - For Load, Update, Stream and Export operators (i.e. fastload, multiload, tpump and fastexport respectively). [/background][/size][/font][/color][/left] [left][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(217, 226, 236)]mama vaadu cheppina points clear gane vunnayi chudu[/background][/size][/font][/color][/left] [/quote] naa question enti antey ippudu ee renti lo edi ekkada use cheyyali ani anthey Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341028545' post='1302059714'] naa question enti antey ippudu ee renti lo edi ekkada use cheyyali ani anthey [/quote] ade mama ... select ,insert operations chese tappudu use Immediate If ur doing update,load, import and export operations use Bulk option ..... Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 mee stage job lo direct load chestunnaremo .... anduke Bulk option use chestunnaranukunta Core jobs lo select , insert etc etc operations vuntayi kada ...so anduke Immediate option Link to comment Share on other sites More sharing options...
pandemkodi Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='Silver_mani' timestamp='1341028654' post='1302059722'] ade mama ... select ,insert operations chese tappudu use Immediate If ur doing update,load, import and export operations use Bulk option ..... [/quote] stg jobs also we are doing select insert but we using bulk(konnitilo) core jobs also using same using immediate Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341028759' post='1302059733'] stg jobs also we are doing select insert but we using bulk core jobs also using same using immediate [/quote] kani DB utilities use cheyatlemo kada core jobs lo ... correct me if i am wrong Link to comment Share on other sites More sharing options...
pandemkodi Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='Silver_mani' timestamp='1341028817' post='1302059742'] kani DB utilities use cheyatlemo kada core jobs lo ... correct me if i am wrong [/quote] in core jobs not using any utilities only in stg jobs using multiload Link to comment Share on other sites More sharing options...
pandemkodi Posted June 30, 2012 Report Share Posted June 30, 2012 oh yeah artham indi ley mama memu core jobs lo insert update chestam aa option bulk ki vundadhu stg lo only insert so andukey akakda bulk use chesatm thanksa mama naaku monday db2 sybase and informix cheppu Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341028906' post='1302059754'] in core jobs not using any utilities only in stg jobs using multiload [/quote] so max ade ayyuntadi mama ... IF U R USING ANY TERADATA UTILITIES USE BULK OPTION OR ELSE IMMEDIATE OPTION Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341028986' post='1302059761'] oh yeah artham indi ley mama memu core jobs lo insert update chestam aa option bulk ki vundadhu stg lo only insert so andukey akakda bulk use chesatm thanksa mama naaku monday db2 sybase and informix cheppu [/quote] em kavali mama ? Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 stage lo updates em vundava ? ante daily incremental load cheskunta potara ??? Link to comment Share on other sites More sharing options...
pandemkodi Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='Silver_mani' timestamp='1341029075' post='1302059773'] em kavali mama ? [/quote] general gaa elati probs vastai sybase informix lo db2 antey konchem touch vundi but sybase and informix teledu meeru queries raastara leka complete ds tool tho chestara Link to comment Share on other sites More sharing options...
Silver_mani Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='pandemkodi' timestamp='1341029213' post='1302059789'] general gaa elati probs vastai sybase informix lo db2 antey konchem touch vundi but sybase and informix teledu meeru queries raastara leka complete ds tool tho chestara [/quote] nenu edaina first sql query lo try cheskunta mama .... like union ,join , simple transformation etc etc anni sql lo entha cheyyocho anta cheskunta ...... aa tarvata naa extract sql raaskunta datstage kosam Link to comment Share on other sites More sharing options...
pandemkodi Posted June 30, 2012 Report Share Posted June 30, 2012 [quote name='Silver_mani' timestamp='1341029171' post='1302059784'] stage lo updates em vundava ? ante daily incremental load cheskunta potara ??? [/quote] yeah memu cdc tool use chestam ani cheppaga change data only istadi adi source db's nunchi Link to comment Share on other sites More sharing options...
Recommended Posts