dalapathi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='fullmeals' timestamp='1364500969' post='1303504645'] Hi all, meelo yevaraina datastage admin backup ichevallu vunnara? Help me [/quote] ee thread lo evaroo admin gaa chesevaallu vunde .... inthakie emi pani cheyyamanaaru ... ??? evarikanna idea vunte chebutaaru
fullmeals Posted March 28, 2013 Report Posted March 28, 2013 Hi Dalapathi (this is my 1st project), indhaka oka prod. database server lo konni datastage jobs valla performance issue vachindhi, so aa jobs anni kill chesi malli run chesaaru but still the same. No improvement. Maa manager vachi nannu chudamannadu, naaku yem arthamkaavatle. Yedho TNS name entry change cheyyamannaru.
pandemkodi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='Silver_mani' timestamp='1364497719' post='1303504273'] mee vadu cheppindi correcte mama .... you cant scan the entire table every time if such huge records are there .....nenu cheppindi follow aipoyi script raasey [/quote] no need of script bayya oka table create chesa sql server lo(source idi) job run ina tarvata max(last_processed_dttm) ni aa crate chesina table lo vestunna datastage job use chesi main job lo sql server source table and create chesina tables ni join chesi dates meeda filter chestunn bayya ..script antey naaku bayam 1
pandemkodi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='dalapathi' timestamp='1364499980' post='1303504520'] [/quote] thanks bayya maa vaadu users tho meeting petti data entha vastado choosi fullscan cheddam anandu maximum thanks dalpathi ,arey o smaba,silver,Manthri
dalapathi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='fullmeals' timestamp='1364501757' post='1303504763'] Hi Dalapathi (this is my 1st project), indhaka oka prod. database server lo konni datastage jobs valla performance issue vachindhi, so aa jobs anni kill chesi malli run chesaaru but still the same. No improvement. Maa manager vachi nannu chudamannadu, naaku yem arthamkaavatle. Yedho TNS name entry change cheyyamannaru. [/quote] TNS name entry aah ... aah TNS names oracle databe ki vuntayai anukuntaa ... kaanie ee issue ki TNS names ki emi sambandam vuntadhi ee DB lo evaro oaktanu vundaali admin ani cheppindu inthaka mundhu okasaari ... ee madhya active vunnadoo ledo
fullmeals Posted March 28, 2013 Report Posted March 28, 2013 Yemo bhayya.Still trying to figure out to understand the requirment. Anyways yevaraina admin vunte please cheppu
pandemkodi Posted March 29, 2013 Report Posted March 29, 2013 Schema reconciliation failed. No conversion between typecodes DATETIME and INT32 for field TIME1 VASTONDI nenu null as time1 ani odbc lo teeskoni oracle lo load chestunna ..odbc sql server ki connect iyi vundi kaasta choodandi itu evarna lenth renditlo emi ivvaledu
qwerty1204 Posted March 29, 2013 Author Report Posted March 29, 2013 [quote name='pandemkodi' timestamp='1364592879' post='1303510481'] Schema reconciliation failed. No conversion between typecodes DATETIME and INT32 for field TIME1 VASTONDI nenu null as time1 ani odbc lo teeskoni oracle lo load chestunna ..odbc sql server ki connect iyi vundi kaasta choodandi itu evarna lenth renditlo emi ivvaledu [/quote] akkada DATETIME ane column lo nunchi INT32 lo ki writing kada baa..andhukee nemoo
qwerty1204 Posted March 29, 2013 Author Report Posted March 29, 2013 I have an I/P column coming as TimeStamp in DataStage and I need to do a subtraction like this CurrentTimestamp - IncomingTimestamp from the column ela chestamu and result ee datatype lo vasthundi??
pandemkodi Posted March 30, 2013 Report Posted March 30, 2013 avi seq file nunchi vastunnaya or database nuncha timestamp column ??
Manthrii Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364600578' post='1303511132'] I have an I/P column coming as TimeStamp in DataStage and I need to do a subtraction like this CurrentTimestamp - IncomingTimestamp from the column ela chestamu and result ee datatype lo vasthundi?? [/quote] date difference ki edho function undedhi [size=4] [/size][size=4] [/size]
qwerty1204 Posted March 30, 2013 Author Report Posted March 30, 2013 [quote name='pandemkodi' timestamp='1364612564' post='1303511743'] avi seq file nunchi vastunnaya or database nuncha timestamp column ?? [/quote] file nunchi ee baa [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](CurrentTimestamp - IncomingTimestamp)[/background][/size][/font][/color] Okati emo DS lo CurrentTimeStamp function use chesi tesukuntamu...inkokati emo file lo nunchi read chestamu
Manthrii Posted March 30, 2013 Report Posted March 30, 2013 [color=#000000][font=arial][size=4]((12 * YearFromDate(Date2)) MonthFromDate(Date2)) - ((12 * YearFromDate(Date1)) MonthFromDate(Date1))[/size][/font][/color] [color=#000000][font=arial][size=4]samba idhemaina work avvudha[/size][/font][/color]
pandemkodi Posted March 30, 2013 Report Posted March 30, 2013 [quote name='Manthrii' timestamp='1364613178' post='1303511786'] [color=#000000][font=arial][size=4]((12 * YearFromDate(Date2)) MonthFromDate(Date2)) - ((12 * YearFromDate(Date1)) MonthFromDate(Date1))[/size][/font][/color] [color=#000000][font=arial][size=4]samba idhemaina work avvudha[/size][/font][/color] [/quote] output number vastada baa ina adi timestamp anta hours mins secs kuda diff kavalemo baa
pandemkodi Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364600578' post='1303511132'] I have an I/P column coming as TimeStamp in DataStage and I need to do a subtraction like this CurrentTimestamp - IncomingTimestamp from the column [b]ela chestamu and result ee datatype lo vasthundi??[/b] [/quote] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]The difference can only be second..and integer is datatype[/background][/size][/font][/color] [size=4]http://www.dsxchange.com/viewtopic.php?p=351854&sid=90a7d9cabaf9f42a4e0d50f6b599f896[/size] [size=4]ee[pi link choodu bayya[/size]
Recommended Posts