Showing posts with label software. Show all posts
Showing posts with label software. Show all posts

Friday, March 30, 2012

Help in Chosing the Software for Reporting Services

Hi All,

I have downloaded SQL Server 2005 Express Edition with Advanced Services SP2 from the following link

http://msdn.microsoft.com/vstudio/express/sql/download/

This I did after hearing Advanced Services provide Reporting Services tool with basic functionalities. After installion I am not able to find the SQL Server Business Intelligence Development Studio. Also there is no provision for installing the Reporting Services.

I already have Visual Studio Express installed.

Could someone tell me what else to download? Also it is asking for another software to be downloaded along with the existing one.

Regards

Karthik

In Visual Studio, when you try and create new projects, do you see a folder called "business intelligence"?|||

I am using Visual Web Developer 2005 Express Edition not Visual Studio. I don't have that option.

I was browsing through many other but couldn't understand clearly what is going wrong. Could you tell me the pre-requisites required for the installation?

|||http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx|||

Thanks for the link...

After lot of searching I figured out the option to install Reporting Services would not appear till IIS is installed. After doing this it is working fine now.

Could you please let me know if installation of SQL Server 2005 Express Edition with Advanced Services SP2 is possible in Vista Home Basic. Nowhere it is clearly explained if it can be done or not.

Monday, March 26, 2012

Help for a one year fresher to enter the software industry

Dear Freinds,
I am hoping a postive answer from this group. I have done my
graduation currently and looking for a break in programming in C# or
VB.NET with SQL Server. After graduation i joined a computer institute
and did a one year course there. For first six months i was nearly
taught nothing. But later some how i started to read things on my own.
After one year i have started attending interviews. But the questions
asked are so much out of topic sometimes. I can completed sample
projects. What should i do because after one year i have come to know
that questions in interviews are so different from actual projects.
For instance i was asked about SOA , damn it i have no idea about that
stuff. I am also reading interview questions and answers from
http://www.questpond.com but i am still not able to cope up.
Please help what approach should i take now. 1 year is a big time
freinds.<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>
Welcome to the real world. (You didn't mention what part of it. That might
help. You may have to leave.)
Landing a first job with no employment experience is tough. Beyond the
obvious -take a shower, clean your nails, and look interested - there is no
simple answer.
You will be hired eventually because an employer thinks you can be a benefit
for him and he likes you. Sometimes all you need is to be likeable. Do
whatever you can to be likeable and appear useful.
For how to be likeable, getting some books, attending some emploment
seminars, etc. may help. Researching as much as you can about the employer
and the job will help you to appear useful.
Beyond that it is all BS, and gaming with a slightly irrational opponent in
charge of the rules. But if you keep plugging it will happen. That's the
positive.
-ralph|||On Oct 14, 1:58 pm, mrnagra...@.yahoo.co.in wrote:
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers fromhttp://www.questpond.combut i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
Two Things.
Firstly, try to go through as many interviews as possible. Usually for
every 15-20 resumes that you send out, you should expect a response of
1. And that is assuming your resume is in line with the job you are
applying for. Keep a track of the jobs you are applying to, what
skills are required, do you show case them in your interview, etc.
You don't have to have experience. But you have to know your stuff. So
e.g. for SOA, try spending a few hours every day learning new
technology. Read an article on WIKI about what SOA is. Then read about
web services. Maybe try building, and consuming a web service in C#.
Learn something new that you see on job listings, but you are not too
sure or confident about.
Stop wasting your money and time going to institutes. At the end of
the day, you will learn the most from your own practice.
Secondly, it is generally easier to get into a entry level QA or
Application Support role than is to get into development. You need to
have good communication skills though, so if you need, work on that as
well. Again, go through as many interviews as possible. The more you
get turned down, the harder you will become, and the better you will
be at the next interview.
I got a job at Bell Canada (Customer Service) working as a Sales Rep
selling TV channels to subscribers. I was making $10 an hour. I kept
giving interviews and stayed sharp with my tech skills. I ended up
getting a job as a Support Analyst with a Bank's IT firm next. I was
making $16 an hour. I still kept updating my skills. I am now an
Intermediate .Net developer with a multi national, making a lot more
than that :)
Keep at it, you will find your way.|||Ralph wrote:
> <mrnagrajan@.yahoo.co.in> wrote in message
> news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
>> Dear Freinds,
>> I am hoping a postive answer from this group. I have done my
>> graduation currently and looking for a break in programming in C# or
>> VB.NET with SQL Server. After graduation i joined a computer
>> institute and did a one year course there. For first six months i
>> was nearly taught nothing. But later some how i started to read
>> things on my own. After one year i have started attending
>> interviews. But the questions asked are so much out of topic
>> sometimes. I can completed sample projects. What should i do because
>> after one year i have come to know that questions in interviews are
>> so different from actual projects.
>> For instance i was asked about SOA , damn it i have no idea about
>> that stuff. I am also reading interview questions and answers from
>> http://www.questpond.com but i am still not able to cope up.
>> Please help what approach should i take now. 1 year is a big time
>> freinds.
> Welcome to the real world. (You didn't mention what part of it. That
> might help. You may have to leave.)
> Landing a first job with no employment experience is tough. Beyond the
> obvious -take a shower, clean your nails, and look interested - there
> is no simple answer.
> You will be hired eventually because an employer thinks you can be a
> benefit for him and he likes you. Sometimes all you need is to be
> likeable. Do whatever you can to be likeable and appear useful.
> For how to be likeable, getting some books, attending some emploment
> seminars, etc. may help. Researching as much as you can about the
> employer and the job will help you to appear useful.
> Beyond that it is all BS, and gaming with a slightly irrational
> opponent in charge of the rules. But if you keep plugging it will
> happen. That's the positive.
> -ralph
Lots of good advice in the two response so far. I second most everything
they said.
That said, I'd like to add:
English apparently isn't your native language, so you should get used to
using spell checks whenever you even come close to anything/anyone related
to the job market.
To more fully grab interest of the readers, you should add such things as
what degrees you have, in what, and where you earned them, along with any
work blocks and/or part time jobs relevant to your goals that you had while
you were in school.
It's tough to gain experience without a job, and tough to get a job without
experience, but it's a catch-22 you can overcome with patience and
perseverance. The comments so far about taking all the interviews you can
get were good ones. The more interview experience the better you'll be
prepared as you work you way through them all. Besides, you might just come
across an entry level job you weren't expecting to find and if it has any
advancement possibilities at all, it can be a good starting point for a
first job.
One thing I don't think was directly mentioned about sending out resumes
is, try to write a cover letter specific for each industry you apply to.
That gives you a chance to expose your goals and your work ethics, things
that aren't part of the resume as a rule. Ideally a cover letter should
only be one page long and do as good a job selling yourself as you can.
Unless you're strapped for cash, don't instantly grab the first offer you
receive. Most places will understand that you need to "think about it" for
a week or so, giving you time to do more research and think about the
overall prospects. But at the same time, don't overlook one that's just
exactly what you want.
A log book or notebook and some samples of your work are often handy at
interviews too, even if they don't look at them. Just having them is an
indicator of your preparedness.
And lastly, try to appear level-headed as possible, even when something
seriously surprises you or excites you to no end<g>. Those who can see
surprises and unexpected events as challenges are usually at the head of the
line. And then, after all that, "Be Yourself" and show a strong work
ethic.
Best of luck,
Pop`|||On Sun, 14 Oct 2007 10:58:47 -0700, mrnagrajan@.yahoo.co.in wrote:
>Dear Freinds,
>I am hoping a postive answer from this group. I have done my
>graduation currently and looking for a break in programming in C# or
>VB.NET with SQL Server. After graduation i joined a computer institute
>and did a one year course there. For first six months i was nearly
>taught nothing. But later some how i started to read things on my own.
>After one year i have started attending interviews. But the questions
>asked are so much out of topic sometimes. I can completed sample
>projects. What should i do because after one year i have come to know
>that questions in interviews are so different from actual projects.
>For instance i was asked about SOA , damn it i have no idea about that
>stuff. I am also reading interview questions and answers from
>http://www.questpond.com but i am still not able to cope up.
>Please help what approach should i take now. 1 year is a big time
>freinds.
I think I see your problem...
Where did you graduate from?|||Hi,
So are you new a team leader? Do you write documentation?
Do you sit any MCIT or other MS cert?
> Secondly, it is generally easier to get into a entry level QA or
> Application Support role than is to get into development. You need to
> have good communication skills though, so if you need, work on that as
> well. Again, go through as many interviews as possible. The more you
> get turned down, the harder you will become, and the better you will
> be at the next interview.
> I got a job at Bell Canada (Customer Service) working as a Sales Rep
> selling TV channels to subscribers. I was making $10 an hour. I kept
> giving interviews and stayed sharp with my tech skills. I ended up
> getting a job as a Support Analyst with a Bank's IT firm next. I was
> making $16 an hour. I still kept updating my skills. I am now an
> Intermediate .Net developer with a multi national, making a lot more
> than that :)
> Keep at it, you will find your way.|||<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Please help what approach should i take now. 1 year is a big time
> freinds.
1 year is not a long time especially seeing you say you didn't learn
anything for the first 6 months. Did you do any programming before this
year? If not I wouldn't hire you with your current level of training. If
this is your only experience then go back and do some more schooling. There
are a lot of people trying to get into the IT industry with minimal
expericence or training.
Michael|||"Michael C" <mike@.nospam.com> wrote in message
news:%23V2Ho4sDIHA.4584@.TK2MSFTNGP03.phx.gbl...
> .
> There are a lot of people trying to get into the IT industry with minimal
> expericence or training.
And they have succeeded.
www.beyondsql.blogspot.com|||"Steve Dassin" <rac4sqlnospam@.net> wrote in message
news:uvoReBtDIHA.1204@.TK2MSFTNGP03.phx.gbl...
> "Michael C" <mike@.nospam.com> wrote in message
> news:%23V2Ho4sDIHA.4584@.TK2MSFTNGP03.phx.gbl...
>> .
>> There are a lot of people trying to get into the IT industry with minimal
>> expericence or training.
> And they have succeeded.
> www.beyondsql.blogspot.com
You've been involved in IT for some time, right? The IT industry used to be
so desperate for people they'd hire anyone. Now it requires a little more
knowledge :-)
Michael|||"Michael C" <mike@.nospam.com> wrote in message
news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> You've been involved in IT for some time, right? The IT industry used to
> be so desperate for people they'd hire anyone. Now it requires a little
> more knowledge :-)
Oops, I din't mean that to sound like it did :-) I started the same way and
suspect I might have trouble getting in now if I tried with my initial
experience.
> Michael
>|||On Oct 14, 10:51 pm, "Michael C" <m...@.nospam.com> wrote:
> "Michael C" <m...@.nospam.com> wrote in message
> news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> > You've been involved in IT for some time, right? The IT industry used to
> > be so desperate for people they'd hire anyone. Now it requires a little
> > more knowledge :-)
> Oops, I din't mean that to sound like it did :-) I started the same way and
> suspect I might have trouble getting in now if I tried with my initial
> experience.
>
>
> > Michael- Hide quoted text -
> - Show quoted text -
I won't suggest going back to school to this individual. The guy has
already spent some hefty amounts I am sure. He needs to practice and
hone his skills. I also won't say that I would not hire him given his
current technical skills. Maybe he just needs to showcase what he
knows better. I remember when I was starting out, I knew a lot, but I
just didn't have enough interview experience, and I would get sweaty
hands and be nervous.
You need to take all of this advice, see what you think are potential
roadblocks for you, and work them out. Stick it out, take it easy, and
have a strategy.
Asad|||"Michael C" <mike@.nospam.com> wrote in message
news:%23k%230PZtDIHA.4028@.TK2MSFTNGP05.phx.gbl...
> "Michael C" <mike@.nospam.com> wrote in message
> news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> > You've been involved in IT for some time, right? The IT industry used to
> > be so desperate for people they'd hire anyone. Now it requires a little
> > more knowledge :-)
> Oops, I din't mean that to sound like it did :-) I started the same way
and
> suspect I might have trouble getting in now if I tried with my initial
> experience.
Nah, I bet most people would be comfortable with the inference from
the first response :)
Sure, just look into this forum for proof that you need a higher
level of knowledge and understanding today than 10 years ago.
It used to be when the smoke clears you could see what's really
going on. But the ability to blow smoke exceeds the patience
of waiting. So now the industry demands a higher level of knowledge
for what is really nothing more than a blow job. Are you kidding me?
Like Elvis, common sense seems to have left the building :-).
www.beyondsql.blogspot.com|||"Steve Dassin" <rac4sqlnospam@.net> wrote in message
news:uf9xnfuDIHA.4360@.TK2MSFTNGP06.phx.gbl...
> Nah, I bet most people would be comfortable with the inference from
> the first response :)
> Sure, just look into this forum for proof that you need a higher
> level of knowledge and understanding today than 10 years ago.
> It used to be when the smoke clears you could see what's really
> going on. But the ability to blow smoke exceeds the patience
> of waiting. So now the industry demands a higher level of knowledge
> for what is really nothing more than a blow job. Are you kidding me?
> Like Elvis, common sense seems to have left the building :-).
Dunno, common sense seems to have settled in a little bit. Some of the
people I used see get hired....
Michael|||mrnagrajan@.yahoo.co.in's wild thoughts were released on Sun,
14 Oct 2007 10:58:47 -0700 bearing the following fruit:
>Dear Freinds,
>I am hoping a postive answer from this group. I have done my
>graduation currently and looking for a break in programming in C# or
>VB.NET with SQL Server. After graduation i joined a computer institute
>and did a one year course there. For first six months i was nearly
>taught nothing. But later some how i started to read things on my own.
>After one year i have started attending interviews. But the questions
>asked are so much out of topic sometimes. I can completed sample
>projects. What should i do because after one year i have come to know
>that questions in interviews are so different from actual projects.
>For instance i was asked about SOA , damn it i have no idea about that
>stuff. I am also reading interview questions and answers from
>http://www.questpond.com but i am still not able to cope up.
>Please help what approach should i take now. 1 year is a big time
>freinds.
Be prepared to take a low paid trainee position. Getting
some experience is more importany initially than the wage.
Jan Hyde
https://mvp.support.microsoft.com/profile/Jan.Hyde|||Some helpful tips
http://www.itjobfeed.com/secrets-of-getting-an-IT-job.asp
<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>|||s'pose no one thinks the cadence of the vernacular of the OP is pretty close to
the opening Paragraph of the link....
<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>|||"MikeB" <m.byerleyATVerizonDottieNettie> wrote in message
news:%23qyZo$xDIHA.4296@.TK2MSFTNGP04.phx.gbl...
> s'pose no one thinks the cadence of the vernacular of the OP is pretty
> close to the opening Paragraph of the link....
Dunno, I didn't click any links.
Michael

Wednesday, March 7, 2012

HELP - Selection of Development Software? Thoughts?

Folks, I have a quick question that I would very much appreciate some
feedback on. We are a not for profit charity organization that has decided
to develop a software in-house to manage our volunteers. We have SQL and
that makes the most sense from a database solution but we have some issues
surrounding the choice of the development language. Some have suggested
100% java while others say Visual Basic. The head of our team has suggested
we do it in Cold Fusion since this will be an internet based application and
I guess I would very much like some feedback on that choice. We have about 5
organizations that we will tie into this system with about 5000 users
logging in once per month.
Any suggestions or comments would be greatly appreciated.

Cheers
WadeFor Web Development, my choice is Codecharge... http://www.codecharge.com/

For desktop applications, I choose Clarion, http://www.softvelocity.com/

Both are very capable.

Tim Morrison

"Wade Eyre" <weyre@.cogeco.ca> wrote in message
news:9vnGb.34812$mV5.1257@.read1.cgocable.net...
> Folks, I have a quick question that I would very much appreciate some
> feedback on. We are a not for profit charity organization that has decided
> to develop a software in-house to manage our volunteers. We have SQL and
> that makes the most sense from a database solution but we have some issues
> surrounding the choice of the development language. Some have suggested
> 100% java while others say Visual Basic. The head of our team has
suggested
> we do it in Cold Fusion since this will be an internet based application
and
> I guess I would very much like some feedback on that choice. We have about
5
> organizations that we will tie into this system with about 5000 users
> logging in once per month.
> Any suggestions or comments would be greatly appreciated.
> Cheers
> Wade|||"Wade Eyre" <weyre@.cogeco.ca> wrote in message
news:9vnGb.34812$mV5.1257@.read1.cgocable.net...
> Folks, I have a quick question that I would very much appreciate some
> feedback on. We are a not for profit charity organization that has decided
> to develop a software in-house to manage our volunteers. We have SQL and
> that makes the most sense from a database solution but we have some issues
> surrounding the choice of the development language. Some have suggested
> 100% java while others say Visual Basic. The head of our team has
suggested
> we do it in Cold Fusion since this will be an internet based application
and
> I guess I would very much like some feedback on that choice. We have about
5
> organizations that we will tie into this system with about 5000 users
> logging in once per month.
> Any suggestions or comments would be greatly appreciated.

What are your developers skilled in?

Personally I'd say ASP. It's free and in my experience works better than
CF.

> Cheers
> Wade|||In article <9vnGb.34812$mV5.1257@.read1.cgocable.net>, weyre@.cogeco.ca
says...
> Folks, I have a quick question that I would very much appreciate some
> feedback on. We are a not for profit charity organization that has decided
> to develop a software in-house to manage our volunteers. We have SQL and

I hope you bought a CPU license for your SQL server as you can not use a
standard CAL for applications that provide data to internet based
applications. The only exception to this is a SBS 2003 install if I
remember correctly.

A CPU license retails for about $4,999.

> that makes the most sense from a database solution but we have some issues
> surrounding the choice of the development language. Some have suggested
> 100% java while others say Visual Basic. The head of our team has suggested
> we do it in Cold Fusion since this will be an internet based application and

Cold Fusion runs on top of IIS, Cold Fusion MX is another beast
entirely.

Since you didn't tell us what the site is for, no technical details, it
will be hard for anyone to tell you what is the best development
platform.

Here are some things to consider -

Have you considered an Off-The-Shelf product?

What languages do your current developers understand?

What is your timeframe for completion?

Did you build a list of requirements and template the user interfaces
and get signoff from the people that will be using the system on a daily
basis - you don't need to know what platform you will use to mock up
some templates to fit the requirements definitions.

What Server platforms are you currently running, supporting, have
experience with?

Are you hosting the application in your facility or external location?

If internal, did you purchase a firewall yet?

Answer all these and we can tell you what would be best.

Without the above, I can say the following:

If your people are MS types, go with .Net, it's as fast as other
platforms.

If you people are not MS types, and your servers are Linux based, go
with a java platform.

I've built large sites to manage people with my coding teams, we've done
every platform known and have no preference for any of them. It all
comes does to what the supporting organization is able to manage, what
the clients people know, and what the client wants to use.

..Net or Java, either one works great. Stay away from CF if you can.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)|||"Wade Eyre" <weyre@.cogeco.ca> wrote in message news:<9vnGb.34812$mV5.1257@.read1.cgocable.net>...
> Folks, I have a quick question that I would very much appreciate some
> feedback on. We are a not for profit charity organization that has decided
> to develop a software in-house to manage our volunteers. We have SQL and
> that makes the most sense from a database solution but we have some issues
> surrounding the choice of the development language. Some have suggested
> 100% java while others say Visual Basic. The head of our team has suggested
> we do it in Cold Fusion since this will be an internet based application and
> I guess I would very much like some feedback on that choice. We have about 5
> organizations that we will tie into this system with about 5000 users
> logging in once per month.
> Any suggestions or comments would be greatly appreciated.
> Cheers
> Wade

Hi Wade,
5000 users once a month is relatively speaking a small site. I second
Greg's opinion that your developer's skill set really should determine
what language to use. Java, asp, and cf are capable languages. It's
really up to the developer if he's going to make you a cadillac of a
site or an unmanageable mess. In my opinion web developement is still
more art than science. Because the developer needs to be
knowledgeable in sql, java/asp/cf, html, style sheets, javascript and
windows/unix.

Help - Multi values dimensions ?

Hello all
we developped a software with a data warehouse in sql server, without using
analysis services, and following the star design.
we are working with data about transactions, with caracteristics modeled in
dimensions. in general each transaction has one single value for each
caracteristic, but for one, it may have more than one or no value.
some solution we thought about:
-we use comma separated IDs (string) in the dimension in the fact table, but
it would hurt indexing
-or store the IDs in a separate table, but each query will require a join
my question is what is the best way to implement this feature ?
thank you for your help
its a standard "n-n" relationship.
1 caracteristic, can have 0 to N transacions
1 transaction can have 0 to N caracteristic
So, you'll have 3 tables:
Caracteristics 1 - n CaractToTransac n - 1 Transactions
The CaractToTransac table contain only 2 columns:
CaracteristicID and TransactionID
(maybe you can add a column called "sequence" if the order of your
caracteristics is important for you)
Now you have multi caracteristics for each transaction.
"r_samir" <r_samir@.discussions.microsoft.com> a crit dans le message de
news:8E2216BF-50D7-4FF6-89A3-C1995D83E3B5@.microsoft.com...
> Hello all
> we developped a software with a data warehouse in sql server, without
using
> analysis services, and following the star design.
> we are working with data about transactions, with caracteristics modeled
in
> dimensions. in general each transaction has one single value for each
> caracteristic, but for one, it may have more than one or no value.
> some solution we thought about:
> -we use comma separated IDs (string) in the dimension in the fact table,
but
> it would hurt indexing
> -or store the IDs in a separate table, but each query will require a join
> my question is what is the best way to implement this feature ?
> thank you for your help