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

[qwerty1204]

[quote name='arey ooo samba' timestamp='1330988189' post='1301482645']

nuvvu cheppina example base chesukoni ee below points ki ela relate chestamoo konchem cheppu baa


[color=#000000][font=Calibri,]1.Fact table - Table with Collection of [b]Foreign Keys corresponding to the Primary Keys in Dimensional table[/b]. Consists of fields with numeric values.[/font][/color]
[color=#000000][font=Calibri,]2.Dimension table -[b] Table with Unique Primary Key.[/b][/font][/color]
[color=#000000][font=Calibri,]3.Load -[b] Data should be first loaded into dimensional table. Based on the primary key values in dimensional table, the data should be loaded into Fact table.[/b][/font][/color]
[/quote]

vaddu lee baa..ardamyindi

[pandemkodi]

pirst pirst dimesnion tables lod chestaru baa

cust_no(primary)
cust_name
cust_zip

emp_no(primarY)
emap_name
store_no

first dimension tbl load chestyru

taravta
fact lo

cust_no
emp_no
no_item_sold
item_price
inkemina avg kaavaalantey avi

ila fact load chesatru

next view raasetappudu

ee keys ni use chesukoni join chesatru

[qwerty1204]

[quote name='pandemkodi' timestamp='1330989247' post='1301482709']
pirst pirst dimesnion tables lod chestaru baa

cust_no(primary)
cust_name
cust_zip

emp_no(primarY)
emap_name
store_no

first dimension tbl load chestyru

taravta
fact lo

cust_no
emp_no
no_item_sold
item_price
inkemina avg kaavaalantey avi

ila fact load chesatru

next view raasetappudu

ee keys ni use chesukoni join chesatru
[/quote]

thanx baa

chivarloo view rasetapudu annavu kada...antee enti??

for example mana project loo ee dataware housing concept use chestunnaru ani adigithe..two or moree concepts use chestunnamu ani cheppachaa like.. start schema and slowly changing dimension rendu use cheyachaa aa asalu okee project loo?

[pandemkodi]

yaa use cheyyochu baaa

slowly changing dimension anedi table type baaa
like
typw-1 table

type-2 table ala istaru kada mapping doc lo adi

general gaa star aa snowflake aa ani adugutaaaru
maa project lo em use chestunnamo kuda naaku telvadu

and view anedi virtual table baa sql lo data emi vundadhu
manam BO lo views use cheskuntam kada reports kosam

[qwerty1204]

[quote name='pandemkodi' timestamp='1330989860' post='1301482755']
yaa use cheyyochu baaa

slowly changing dimension anedi table type baaa
like
typw-1 table

type-2 table ala istaru kada mapping doc lo adi

general gaa star aa snowflake aa ani adugutaaaru
maa project lo em use chestunnamo kuda naaku telvadu

and view anedi virtual table baa sql lo data emi vundadhu
manam BO lo views use cheskuntam kada reports kosam
[/quote]

yaa views BO loo untadi ani vinnanu baa...datastage job loo ila reports generate chyedamu..BO tools use cheyadmu kuda untadaa?

[pandemkodi]

[quote name='arey ooo samba' timestamp='1330990561' post='1301482792']

yaa views BO loo untadi ani vinnanu baa...datastage job loo ila reports generate chyedamu..BO tools use cheyadmu kuda untadaa?
[/quote]
view is sql object baaa

each and every table ki underlying view vuntadi dwh lo to create reports in BO(or any report tool)

it is like virtual table create view ani enni tables nina join cheskovachhu manam


general gaa manam dimesion facts loki data load chesina tarvaata database people views raastaaru baa according to business req

appudu database ni BO ni connect chesukuntaaru BO people appudu ee views ni use chesi drag and drop chestaru BO lo

so final gaa view is sql thing BO lo reports generate cheyyadaniki use chestaru

and DS lo reports gurinchi naaku teliyadu baa(vundahu anukunta)

[pavan_613]

Not a great thread

[pavan_613]

Vammoooo antha talented batch anukunta neenu jump

[pavan_613]

Vammoooo antha talented batch anukunta neenu jump

[pavan_613]

Vammoooo antha talented batch anukunta neenu jump

[qwerty1204]

[quote name='pandemkodi' timestamp='1330990920' post='1301482820']
view is sql object baaa

each and every table ki underlying view vuntadi dwh lo to create reports in BO(or any report tool)

it is like virtual table create view ani enni tables nina join cheskovachhu manam


general gaa manam dimesion facts loki data load chesina tarvaata database people views raastaaru baa according to business req

appudu database ni BO ni connect chesukuntaaru BO people appudu ee views ni use chesi drag and drop chestaru BO lo

so final gaa view is sql thing BO lo reports generate cheyyadaniki use chestaru

and DS lo reports gurinchi naaku teliyadu baa(vundahu anukunta)
[/quote]

monna IBM vadu vachi BO medha demo ichadu baa..andhuloo vinnaun..ee views..universe lo create chestamu ani cheppadu...

[pandemkodi]

[quote name='arey ooo samba' timestamp='1330991524' post='1301482862']

monna IBM vadu vachi BO medha demo ichadu baa..andhuloo vinnaun..ee views..universe lo create chestamu ani cheppadu...
[/quote]
ee universe baa

universe antey business objects anukuntaa(generalise chesi cheppi vuntaddu every reporting ki universe vuntadi )

ibm vaadidhi edo vundi reporting tool

[bhargava_v]

[quote name='CITI' timestamp='1330991339' post='1301482853']
Vammoooo antha talented batch anukunta neenu jump
[/quote]
[quote name='CITI' timestamp='1330991354' post='1301482855']
Vammoooo antha talented batch anukunta neenu jump
[/quote]
[quote name='CITI' timestamp='1330991367' post='1301482856']
Vammoooo antha talented batch anukunta neenu jump
[/quote]

enni sarlu jumputhavu?

[qwerty1204]

[quote name='pandemkodi' timestamp='1330991614' post='1301482866']
ee universe baa

universe antey business objects anukuntaa(generalise chesi cheppi vuntaddu every reporting ki universe vuntadi )

ibm vaadidhi edo vundi reporting tool
[/quote]

yaa BO ki related ee baa

[tom bhayya]

[img]http://lh6.ggpht.com/-Eoyjpy5n2PM/TnyuNWl4-OI/AAAAAAAAEWE/uc5DeoeG3_s/Brahmi-3.gif[/img][img]http://lh6.ggpht.com/-Eoyjpy5n2PM/TnyuNWl4-OI/AAAAAAAAEWE/uc5DeoeG3_s/Brahmi-3.gif[/img]