pandemkodi Posted February 23, 2012 Report Share Posted February 23, 2012 naaku first two rows vadhu baaa third nunchi read cheyyali read method:file pattern Link to comment Share on other sites More sharing options...
dalapathi Posted February 23, 2012 Report Share Posted February 23, 2012 Link to comment Share on other sites More sharing options...
irritation Posted February 23, 2012 Report Share Posted February 23, 2012 [quote name='pandemkodi' timestamp='1330030330' post='1301444871'] babu sequentil file lo third row nundi read cheyyali ela [/quote] [quote name='pandemkodi' timestamp='1330032739' post='1301445160'] naaku first two column vadhu baaa third nunchi read cheyyali read method:file pattern [/quote] baa first two rows akkarleda.... first two colums akkarleda... first two colums akkarledu ante... dalapathi ba cheppinattu cheyyi... first two rows vaddu ante.. i think tail vadocchu anukuntunna... reference ki idi choodu [url="http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.parjob.dev.doc%2Ftopics%2Fr_deeref_Partitioning_Tab_tail_stage.html"]http://publib.boulde...tail_stage.html[/url] Link to comment Share on other sites More sharing options...
dalapathi Posted February 23, 2012 Report Share Posted February 23, 2012 [quote name='pandemkodi' timestamp='1330032739' post='1301445160'] naaku first two column vadhu baaa third nunchi read cheyyali read method:file pattern [/quote] okati clear cheyyi...........nuvvu 1st two rows avasarma ledaa..........first 2 columns aah....... first 2 columns ayithey.........sequential file lo first annie read chesi..........next transformer lo aah renditini output ki map cheyyaku..........i mean.......drop chesey......... first 2 rows vaddanukuntey.........unix command vaadaalanukuntaa.......naaku adhi teliyadhu........evariana unix vaalalni adigi chebuthaaru anukutnaa Link to comment Share on other sites More sharing options...
dalapathi Posted February 23, 2012 Report Share Posted February 23, 2012 [quote name='irritation' timestamp='1330033388' post='1301445211'] baa first two rows akkarleda.... first two colums akkarleda... first two colums akkarledu ante... dalapathi ba cheppinattu cheyyi... first two rows vaddu ante.. i think tail vadocchu anukuntunna... reference ki idi choodu [url="http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.parjob.dev.doc%2Ftopics%2Fr_deeref_Partitioning_Tab_tail_stage.html"]http://publib.boulde...tail_stage.html[/url] [/quote] adhey okasaari.....first 2 rows vaddananadu..........okasaari first 2 columns annaadu.......... Link to comment Share on other sites More sharing options...
pandemkodi Posted February 23, 2012 Report Share Posted February 23, 2012 data coming like this NAME ********* pandemkodi panipuri dala irri deenlo NAME and ***** two different rows naaku avi vadhu only dala,pandemkodi avi kaavali artham inda Link to comment Share on other sites More sharing options...
pandemkodi Posted February 23, 2012 Report Share Posted February 23, 2012 [quote name='dalapathi' timestamp='1330033433' post='1301445215'] okati clear cheyyi...........nuvvu 1st two rows avasarma ledaa..........first 2 columns aah....... first 2 columns ayithey.........sequential file lo first annie read chesi..........next transformer lo aah renditini output ki map cheyyaku..........i mean.......drop chesey......... first 2 rows vaddanukuntey.........unix command vaadaalanukuntaa.......naaku adhi teliyadhu........evariana unix vaalalni adigi chebuthaaru anukutnaa [/quote] actual gaa firt 2 rows vadhu baaa naaku nenu use chesedhi read format vachi: FIle patteren so filter option kuda pani cheyyadu unix command ivvataaaniki i hope u understand Link to comment Share on other sites More sharing options...
dalapathi Posted February 23, 2012 Report Share Posted February 23, 2012 [quote name='pandemkodi' timestamp='1330033910' post='1301445263'] data coming like this NAME ********* pandemkodi panipuri dala irri deenlo NAME and ***** two different rows naaku avi vadhu only dala,pandemkodi avi kaavali artham inda [/quote] ooh ok.....antye vaallu edho header pampisthunanaur annamaata....... so, initial gaa oka seq. file stage petti total data oka column laagaa read cheyyi..........edho oka column name ichi varchar 300 ooh 400 ooh length ichi........nee file lo vunna columns annie pattey laagaa...... next oka transformer lo.......constraint pettu........oka vela NAME anedhi vasthundanukoo header lo.....constraint lo itla raayi link.inputcolumn[1,4] <> "NAME" next deeni output ni oka column import stage ki pettu........aah column import lo aah sequential file stage lo metadata emundhoo...........antye enni columns vunnaayoo.........anni import chesukoo....... so, idhi aah first lo vunan header povataaniki........2 rows teeseyyatam etlaanoo telidhu......mundhu ayithey idhi chesi chuudu workout avvuddho ledhoo..... Link to comment Share on other sites More sharing options...
pandemkodi Posted February 23, 2012 Report Share Posted February 23, 2012 idi ok baaa only header ithey teeyochu baa but aa next ******** gurinchi naa baaadha Link to comment Share on other sites More sharing options...
dalapathi Posted February 23, 2012 Report Share Posted February 23, 2012 Adhey constraint lo ani and inputcolumn[1,3]<> "***" ani pedithey raavatledaa...? From mobile Link to comment Share on other sites More sharing options...
irritation Posted February 23, 2012 Report Share Posted February 23, 2012 bhaiyya... inkoka solution enti ante... neeku sequential file lo nunchi data read chesetappudu oka option untundi... first line is column name: true/false adi true pedithe it wont read the first row. appudu aa data motham ni inkoka temporary seq file lo ki copy cheyyi.... ala two times consecutive ga cheyyi idi koncham lengthy process and ila cheyyadam entha varaku correct oo naku teliyadu... but then you will have the data... Link to comment Share on other sites More sharing options...
pandemkodi Posted February 23, 2012 Report Share Posted February 23, 2012 data mottam oka seq file lo load cheyyadaniki nenu oka file ni read cheyytla baa............chala files ni okesaari manaki read format vundi kada:file patteren ichanu foe ex .d vunna anni files ni read chestadi so appudu data antha ala oka seq file load cheyyadam kudardu anukunta (not sure) Link to comment Share on other sites More sharing options...
dalapathi Posted February 23, 2012 Report Share Posted February 23, 2012 Asalu variety gaa data lo 2 rows vaddannaara...! Header next chukkalu ayithey constraint lo pedithey potaati...kaani anni files okesaari read chesi prathi file data nundi 2 records aah...!!! From mobile Link to comment Share on other sites More sharing options...
pandemkodi Posted February 23, 2012 Report Share Posted February 23, 2012 [quote name='dalapathi' timestamp='1330036714' post='1301445522'] Asalu variety gaa data lo 2 rows vaddannaara...! Header next chukkalu ayithey constraint lo pedithey potaati...kaani anni files okesaari read chesi prathi file data nundi 2 records aah...!!! From mobile [/quote] yeah baaa first header then *******(star lu) then pandem rovo vat data ee file ichevaadu pedda talmaasina vaadu Link to comment Share on other sites More sharing options...
qwerty1204 Posted February 24, 2012 Author Report Share Posted February 24, 2012 do like this baa...system varialbe okti untadi @INROWNUM ani transformer stage loo...constraint loo ila manetion cheyi if @INROWNUM > 2 so tht neeku first two rows raavu Link to comment Share on other sites More sharing options...
Recommended Posts