Rohit,

Why not use the TopCount function?

This is very vague...a datawarehouse design template will vary as the business type changes...there exists no fixed template as far as i know, I might be wrong!!

What is the nature...

Sam1980 (9/23/2010)

---

Hi All,

I need to grab the results of a select statement in a variable and there are more than 1 rows in the result, but just one column.

I...

Now definitely i'll be using a REGEX

Pinky,

Use the Image Tool provided

abhitkumar (9/23/2010)

---

Hello All Experts,

In my live server we have total nos of approx 200 reports and 50 email subscriptions created by us.

Now we are planning to change our existing hardware...

You may use the Derived Transformation task.

Option 1:Functions such as REPLACE, LEN, SUBSTRING might prove useful

OR

Option 2: Use Script Component in Transformation Mode or Source Mode and use the Trim()...

Bianca,

Lucky you!!!

I would suggest the following:

Number of users hitting the site region specific

Average number of tweets per region per hours

Expected Server down time

Sentiment analysis

Great question!!!

Groovy..:cool::cool::cool:

How about facebook:-P:-P

ns.sharath (9/21/2010)

---

Hi,

I am doing a lookup on a reference table and it returns 2 matches on the key and I want to use both the matches. Is there any way...

What kind of transformation are you using...

😀 Just two seconds after submitting my initial response, which contained a question, I realised it was, as Basil Fawlty might say, BLEEDIN' OBVIOUS! An immediate edit was required to...

Probably because you still have the DelayValidation as true

The entire idea is to store date as an unique integer value for performance enhancements

the default format of dd:mm:yy hh:mm:ss is not a good practice