Ms Sql Server Technology Discussions

[9Pardhu]

[quote name='captcha' timestamp='1362254050' post='1303356113']
Group lo kothaga join ayyanu, pleasant surprise to see this topic !
Chala manchi material undi..

Thanks & appreciate all the posters & followers of this topic..
[/quote]

Whats ur Background?

[9Pardhu]

SQL Server DBA's Entha mandi vunnaru ikkada?

[deals2buy]

[quote name='calmandquiet' timestamp='1362496130' post='1303368874']
Calling SSAS thopulu


[b]AFAIK Facts & Dimensions are base tables and based on those tables you build Cubes[/b]
----what is SSAS Dev role just cubes okkate create chesi reports generate cheyala or facts and dimension tables kuda create cheyala.
[b]Asalu DW ante nuvvem anukuntunnavo koddiga cheppu mundu[/b]
[size=4]--Database ki schema(star and schema) with dimensions and facts arrange cheyali kada which is a OLAP.[/size]
3)SSAS tasks ela vuntavi ...

[b]depends...you may need to writer MDX Queries sometimes...leda you can just build the cubes using tools...varies from work to work locations.[/b]
---So SSAS job role mainly MDX Queries ans Creating cubes aantava baaa???
[b][color=#FF0000]but edaina nuvvu kashtapadalasinde [/color][/b]
----Try chesthunanu cubes create cheyatam easy gane vundi but how to create dimensions and facts (schema) ala create cheyalo ardam kavatam ledu [img]http://www.desigifs.com/sites/default/files/brahmam_style15_1.gif?1290369188[/img]
[/quote]most of the questions kinda love bhayya answer chesadu chudu
[quote name='calmandquiet' timestamp='1362496304' post='1303368889']
SSIS Packages to import data daily from OLTP Applications to data [size=4]warehouse Evvaraina chesara ?????[/size]
[/quote]nenu intha varaku SSIS eh use cheyyaledu asalu
[quote name='loveindia' timestamp='1362499278' post='1303369204']

Facts and dimensions are just like tables in RDBMS.

First things to consider before creating facts and dimensions.. Should you follow Inman - Kimball Methodologies.? which are other wise called STAR SCHEMA and SNOW FLAKE SCHEMA. you should which one you should pick and why?

Then you should ask yourself, Have I ever done Data Modelling before? If the answer is yes, then you should go ahead and create Tables (Facts and dimension) / Primary Keys / Foreign Keys / Indexes and then make ways to pull data into your Data warehouse.

In short this is all you need to know to define Facts & Dimensions.
[/quote]

[loveindia]

[quote name='calmandquiet' timestamp='1362496304' post='1303368889']
SSIS Packages to import data daily from OLTP Applications to data [size=4]warehouse Evvaraina chesara ?????[/size]
[/quote]

chesanu... MYSQL to SQL..
SQL to SQL..
legacy systems to SQL..
etc..,

tell me what are your wants..

[calmandquiet]

[quote name='loveindia' timestamp='1362504483' post='1303369667']

chesanu... [size=5]MYSQL to SQL..
SQL to SQL[/size]..
legacy systems to SQL..
etc..,

tell me what are your wants..
[/quote]
Konchem info share chey ra plzz

[loveindia]

[quote name='calmandquiet' timestamp='1362511082' post='1303370339']
Konchem info share chey ra plzz
[/quote]

coming soon... wait chey... post chesta live videos..

Info antey emanna questions untey exact ga adugu chepta...

[calmandquiet]

[quote name='loveindia' timestamp='1362511561' post='1303370362']

coming soon... wait chey... post chesta live videos..

Info antey emanna questions untey exact ga adugu chepta...
[/quote]
SSAS job tasks ala vuntavi

ex:-creating cubes and reports na or something else

[loveindia]

Building cubes, sinna pillodu kuda sestaadu vay...

creating KPI's, Semi-Additive Measures, Additive Measures, Calculated Members, Incremental Data loads for cubes, Perspectives, Defining Hierarchies (Rigid / Flexible), MDX queries etc., Its an ocean man... oka manchi startup company lo paditey ivanni 4 months lo nerchukuntaav... aa tarvataa projects picha lite untai...

are you working now or OPT or what? just book ur future now man...

[captcha]

[quote name='Kaarthikeya' timestamp='1362421098' post='1303364403']

Welcome to the league
[/quote]

Thanks!

[captcha]

[quote name='pardhu9' timestamp='1362499714' post='1303369259']
Whats ur Background?
[/quote]
Analysis, Reporting antaga raavu..migathavi bane chesta..

[ghazni]

SSIS Experts.......

Nenu konni pacjkages test chesyali aitey Test server ki veli chestuna....... Na question enti antey packages test chesey tapudu Configuration files disable chestuna...... so local environment lo test chedamani.......

ipudu master package untey child packages kuda nenu master package run chesey project loney undali kada alaney chestuna............

1. Asalu Configuration gurunchi chadiva kani konchem mana basha lo artam ayettu cheptara........
2. Na packages lo Exute package task undi andulo nenu path change chesani kani enta save chesina default ga patha danikey velipotundi ......(ikada path change kaka poyina na project lo una packages ney tisukuntundi so no problem kada )

[Darling999]

[quote name='ghazni' timestamp='1362881787' post='1303395556']
SSIS Experts.......

Nenu konni pacjkages test chesyali aitey Test server ki veli chestuna....... Na question enti antey packages test chesey tapudu Configuration files disable chestuna...... so local environment lo test chedamani.......

ipudu master package untey child packages kuda nenu master package run chesey project loney undali kada alaney chestuna............

1. Asalu Configuration gurunchi chadiva kani konchem mana basha lo artam ayettu cheptara........
2. Na packages lo Exute package task undi andulo nenu path change chesani kani enta save chesina default ga patha danikey velipotundi ......(ikada path change kaka poyina na project lo una packages ney tisukuntundi so no problem kada )
[/quote]

1. Config file Antey nuvvu pass chesey parameter bayata file nundi pass avtundi jus for instance:

Assume there is a query select * from tbl where I'd between ? And ? Ila Ichaav anukoo. Mee variable lo query untundi but daaniki values Maatram confit file nundi pass avtaayi. So nuvvu confit disable chesinappudu Aah values direct or variables thru pass chestaav.

2. Chk whether ur packages are in the right path, which u are defining in. Also ne patha proj lo unna packages ni pick cheskuntey tarvaatha changes chesinappudu avi effect avtaayi, so keep then in a seperate path and run them.

[mtkr]

[quote name='ghazni' timestamp='1362881787' post='1303395556']
SSIS Experts.......

Nenu konni pacjkages test chesyali aitey Test server ki veli chestuna....... Na question enti antey packages test chesey tapudu Configuration files disable chestuna...... so local environment lo test chedamani.......

ipudu master package untey child packages kuda nenu master package run chesey project loney undali kada alaney chestuna............

1. Asalu Configuration gurunchi chadiva kani konchem mana basha lo artam ayettu cheptara........
2. Na packages lo Exute package task undi andulo nenu path change chesani kani enta save chesina default ga patha danikey velipotundi ......(ikada path change kaka poyina na project lo una packages ney tisukuntundi so no problem kada )
[/quote]


ne exe pkg tsk variables ni read chesthundemooo chusava mama!!!?

[mtkr]

[quote name='DARLING...' timestamp='1362883435' post='1303395697']
1. Config file Antey nuvvu pass chesey parameter bayata file nundi pass avtundi jus for instance:

Assume there is a query select * from tbl where I'd between ? And ? Ila Ichaav anukoo. Mee variable lo query untundi but daaniki values Maatram confit file nundi pass avtaayi. So nuvvu confit disable chesinappudu Aah values direct or variables thru pass chestaav.

2. Chk whether ur packages are in the right path, which u are defining in. Also ne patha proj lo unna packages ni pick cheskuntey tarvaatha changes chesinappudu avi effect avtaayi, so keep then in a seperate path and run them.
[/quote]


asalu package ki configurations unnai ani vatini chk chesukovaali ani ela telustadhiii???

oka eadva intw lo adigaaadu.....

[ghazni]

[quote name='DARLING...' timestamp='1362883435' post='1303395697']
1. Config file Antey nuvvu pass chesey parameter bayata file nundi pass avtundi jus for instance:

Assume there is a query select * from tbl where I'd between ? And ? Ila Ichaav anukoo. Mee variable lo query untundi but daaniki values Maatram confit file nundi pass avtaayi. So nuvvu confit disable chesinappudu Aah values direct or variables thru pass chestaav.

2. Chk whether ur packages are in the right path, which u are defining in. Also [b]ne patha proj lo unna packages ni pick cheskuntey tarvaatha changes chesinappudu avi effect avtaayi, so keep then in a seperate path and run them[/b].
[/quote]

nenu anni packages vere folder loki tisukuna ........ and project lo add chesetapudu existing files nunchey chesa..... aitey execute package connection manager lo ipudu una packages path istuna kani enta save chesina malli patha packages path key potundi...... aa execute package task lo unavi child packages.... kani master package execute chesinapudu na project lo una child packages ey execute avtunayi.......... naku adey kavali kani by any chance aa path change avakunda original packages lo changes kavu kada......