Jump to content

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


qwerty1204

Recommended Posts

[quote name='pandemkodi' timestamp='1332182590' post='1301533265']
cut -d "," -f4,5,6,7,8 filename---will give u only 4 5 6 7 8 columns

ee command working avutondi baa unix lo ithey

deenni seq file lo filter options lo petti choodu ostadi
[/quote]

thanx baa :)

sequential file stage properties lo alanti option emi ledaa baa

Link to comment
Share on other sites

[quote name='arey ooo samba' timestamp='1332182763' post='1301533270']

thanx baa :)

sequential file stage properties lo alanti option emi ledaa baa
[/quote]
seq file lo alantio option ledanukunta baa

andukey filter option ichadu unix use cheskodaaniki

Link to comment
Share on other sites

[quote name='pandemkodi' timestamp='1332183322' post='1301533292']
seq file lo alantio option ledanukunta baa

andukey filter option ichadu unix use cheskodaaniki
[/quote]

oh kk..so parallel job lo matram cheyalemu antava..we have to run unix command outside of DS and get tht file as input to DS aa

Link to comment
Share on other sites

[quote name='arey ooo samba' timestamp='1332186443' post='1301533576']

oh kk..so parallel job lo matram cheyalemu antava..we have to run unix command outside of DS and get tht file as input to DS aa
[/quote]
no no
seq file ee unix command ivvataniki oka option vundi adi
filter aney option

aa filter lo ee
command ivvu baa
vachestadi

Link to comment
Share on other sites

[quote name='pandemkodi' timestamp='1332187540' post='1301533682']
no no
seq file ee unix command ivvataniki oka option vundi adi
filter aney option

aa filter lo ee
command ivvu baa
vachestadi
[/quote]

yaa ippude aa option chusanu baa.. syntax same ee naa baa..unix loo edhi aite istamoo adhee command isthe enough aa

Link to comment
Share on other sites

[quote name='arey ooo samba' timestamp='1332187761' post='1301533708']
yaa ippude aa option chusanu baa.. syntax same ee naa baa..unix loo edhi aite istamoo adhee command isthe enough aa
[/quote]
yaa baa

unix lo filename kuda istam kada but seq file stage lo filenmae akkarledu anukunta
endukantey manm teeskoney file ee kada input

Link to comment
Share on other sites

[quote name='arey ooo samba' timestamp='1332188499' post='1301533779']
The file I have doesn't have any column names in it baa...then how to do it :(
[/quote]
column names tho panledu baa

just delimiter anthey

cut -d "," -f1,2 filename(unix box lo)

daanlo 1,2 anevey columns and D tarvata quotes lo vunna , vundi choodu adi delimiter baa

so nuvvu avi choostey chaalu names akkarla

ikkada neeku 1,2 columns lo vunna data ni display chestadi unix lo

and neeku kaavlsindi 4 to 8 kada

cut -d "delimeter" -f4,5,6,7,8 filename

Link to comment
Share on other sites

[quote name='pandemkodi' timestamp='1332189001' post='1301533837']
column names tho panledu baa

just delimiter anthey

cut -d "," -f1,2 filename(unix box lo)

daanlo 1,2 anevey columns and D tarvata quotes lo vunna , vundi choodu adi delimiter baa

so nuvvu avi choostey chaalu names akkarla

ikkada neeku 1,2 columns lo vunna data ni display chestadi unix lo

and neeku kaavlsindi 4 to 8 kada

cut -d "delimeter" -f4,5,6,7,8 filename
[/quote]

yaa got it baa

Link to comment
Share on other sites

konni interview questions about Dataware housing...vetiki answers simple ga ela cheppachoo cheppandi baa



1.What are the different Dimensional modeling Techniques are Available?

2. What is the Difference between Top-down Approach and Bottom-up Approach?


3. What is the life cycle of Data warehousing project?


anni questions okee sari vesthe interest pothundi ani..dng it few at a time ))(<

Link to comment
Share on other sites

[quote name='arey ooo samba' timestamp='1332267057' post='1301536894']
konni interview questions about Dataware housing...vetiki answers simple ga ela cheppachoo cheppandi baa



1.What are the different Dimensional modeling Techniques are Available?

2. What is the Difference between Top-down Approach and Bottom-up Approach?


3. What is the life cycle of Data warehousing project?


anni questions okee sari vesthe interest pothundi ani..dng it few at a time ))(<
[/quote]


[color=#333333][size=4][font=arial, helvetica, sans-serif]1. [b]Star Schema:[/b][/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif][b]Snow Flake Schema:[/b][/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif][b]Galaxy Schema:[/b][/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif][b]Fact Constellation Schema:[/b][/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif]FOR ADDITIONAL INFO:[/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif][url="http://www.folkstalk.com/2010/01/data-warehouse-dimensional-modelling.html"]http://www.folkstalk...-modelling.html[/url][/font][/size][/color]

[color=#333333][size=4][font=arial, helvetica, sans-serif]2. [color=#000000]top down design starts from abstract to finally achieve a solid design, bottom up approach is just the reverse as it begins with the concrete design to get to abstract entity. When it comes to designing brand new systems, it is top down approach that is most commonly employed. On the other hand, in the case of reverse [/color][url="http://www.differencebetween.com/category/business/engineering/"]engineering[/url][color=#000000] as when it is the goal to understand someone else’s design, bottom up approach is utilized.[/color][/font][/size][/color]

[color=#333333][size=4][font=arial, helvetica, sans-serif]3. Datawarehousing projects are categorized into 4 types.[/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif]1) Development Projects.
2) Enhancement Projects
3) Migration Projects
4) Production support Projects.[/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif]-> The following are the different phases involved in a ETL project development life cycle.[/font][/size][/color]
[color=#333333][size=4][font=arial, helvetica, sans-serif]1) Business Requirement Collection ( BRD )
2) System Requirement Collection ( SRD )
3) Design Phase
a) High Level Design Document ( HRD )
B) Low level Design Document ( LLD )
c) Mapping Design
4) Code Review
5) Peer Review
6) Testing
a) Unit Testing
B) System Integration Testing.
c) USer Acceptance Testing ( UAT )
7) Pre - Production
8) Production ( Go-Live )[/font][/size][/color]

Link to comment
Share on other sites

Mama evaraina Modelling chesara ....Asalu ERwin tool ela vadtaro teliste cheppandi ....nenu ippudu modelling cheyali ...asalu ela start cheyalo artham kavatledu [img]http://i46.tinypic.com/98da8m.gif[/img]

Link to comment
Share on other sites

×
×
  • Create New...