@@@@calling All Datastage Developers@@@@

[pandemkodi]

naaku first two rows vadhu baaa

third nunchi read cheyyali

read method:file pattern

[dalapathi]

[irritation]

[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]

[dalapathi]

[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

[dalapathi]

[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..........

[pandemkodi]

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

[pandemkodi]

[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

[dalapathi]

[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.....

[pandemkodi]

idi ok baaa

only header ithey teeyochu baa

but aa next ******** gurinchi naa baaadha

[dalapathi]

Adhey constraint lo ani and inputcolumn[1,3]<> "***" ani pedithey raavatledaa...?

From mobile

[irritation]

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...

[pandemkodi]

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)

[dalapathi]

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

[pandemkodi]

[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

[qwerty1204]

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