mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='pandemkodi' timestamp='1364617461' post='1303512142'] idantha enduku mundey day chestey telustadiga [/quote] day and time same unna kani year and months different undochu ga.. so first year then months then day... and then hours.
pandemkodi Posted March 30, 2013 Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364618245' post='1303512168'] day and time same unna kani year and months different undochu ga.. so first year then months then day... and then hours. [/quote] wow intha chinnna logic ela miss ayya
dalapathi Posted March 30, 2013 Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364618245' post='1303512168'] day and time same unna kani year and months different undochu ga.. so first year then months then day... and then hours. [/quote] :3D_Smiles:Pakka DB ki nuvvu endhuku raavatledani nee fans adugutunnaaru[size=4] [/size][size=4] [/size]
pandemkodi Posted April 3, 2013 Report Posted April 3, 2013 oka weird problem vastondi oka column vundi sql servr lo varchar256 oracle lo kuda varchar256 icahnu ss source nunchi oracle lo loading using changecapture ..filtering only delta records so nenu oka 1000 records load chesi ...malli sourc elo emi cheange cheyyakunda 2nd time run chestey konni records edit ani vastunnai but emi edit avvaledu avi sql server lo emina control char vuntaya help nenu 50 colmns use cehstunna only okka column ee problem istondi naaku
Silver_mani Posted April 3, 2013 Report Posted April 3, 2013 [quote name='pandemkodi' timestamp='1364966173' post='1303532605'] oka weird problem vastondi oka column vundi sql servr lo varchar256 oracle lo kuda varchar256 icahnu ss source nunchi oracle lo loading using changecapture ..filtering only delta records so nenu oka 1000 records load chesi ...malli sourc elo emi cheange cheyyakunda 2nd time run chestey konni records edit ani vastunnai but emi edit avvaledu avi sql server lo emina control char vuntaya help nenu 50 colmns use cehstunna only okka column ee problem istondi naaku [/quote] this is a very common problem in using CDC stage mama ....Check ur Keys properly ....normal ga keys ni trim chesi clean ga pettuko
pandemkodi Posted April 3, 2013 Report Posted April 3, 2013 [quote name='Silver_mani' timestamp='1364966468' post='1303532635'] this is a very common problem in using CDC stage mama ....Check ur Keys properly ....normal ga keys ni trim chesi clean ga pettuko [/quote] Keys are fine bayya Trim chesi kuda chesa no use
dalapathi Posted April 3, 2013 Report Posted April 3, 2013 [quote name='pandemkodi' timestamp='1364966581' post='1303532647'] Keys are fine bayya Trim chesi kuda chesa no use [/quote] okkosaari edho extra line laaga no edho teesukuntadhi aah type issue emanna naa ... char13 ooh edho function vaadutaaru kadaa aah issue aah
pandemkodi Posted April 3, 2013 Report Posted April 3, 2013 [quote name='dalapathi' timestamp='1364966807' post='1303532668'] okkosaari edho extra line laaga no edho teesukuntadhi aah type issue emanna naa ... char13 ooh edho function vaadutaaru kadaa aah issue aah [/quote] Yeah but database nunchi control chars vastayo adi naa doubt
Silver_mani Posted April 3, 2013 Report Posted April 3, 2013 [quote name='dalapathi' timestamp='1364966807' post='1303532668'] okkosaari edho extra line laaga no edho teesukuntadhi aah type issue emanna naa ... char13 ooh edho function vaadutaaru kadaa aah issue aah [/quote] ???
Silver_mani Posted April 3, 2013 Report Posted April 3, 2013 [quote name='pandemkodi' timestamp='1364967216' post='1303532713'] Yeah but database nunchi control chars vastayo adi naa doubt [/quote] adi unknown hex decimals pad ayyi vuntayi char field aithe ...... Varchar ki aa problem vundakudadu
pandemkodi Posted April 3, 2013 Report Posted April 3, 2013 [quote name='Silver_mani' timestamp='1364967294' post='1303532719'] adi unknown hex decimals pad ayyi vuntayi char field aithe ...... Varchar ki aa problem vundakudadu [/quote] Yea Evo bayya Only sql lo nunchi vastunnai but oracle lo raavatla
Silver_mani Posted April 3, 2013 Report Posted April 3, 2013 [quote name='pandemkodi' timestamp='1364967725' post='1303532759'] Yea Evo bayya Only sql lo nunchi vastunnai but oracle lo raavatla [/quote] $APT_STRINGPADCHAR = 0 X 20 idi set chey ............... appudu nee string ki only spaces pad avutayi ....normal trim vadesi full clean cheseyochu
pandemkodi Posted April 3, 2013 Report Posted April 3, 2013 [quote name='Silver_mani' timestamp='1364967828' post='1303532770'] $APT_STRINGPADCHAR = 0 X 20 idi set chey ............... appudu nee string ki only spaces pad avutayi ....normal trim vadesi full clean cheseyochu [/quote] Ok mama environment Variable ee kada try chesi choosta repu
Silver_mani Posted April 3, 2013 Report Posted April 3, 2013 [quote name='pandemkodi' timestamp='1364967997' post='1303532797'] Ok mama environment Variable ee kada try chesi choosta repu [/quote] yup
Recommended Posts