Skip to main content

SQL, Report Generation Processs

Step 1. Export SQL result in to an csv file
Step 2. Report Validation ( Through Excel )



-------------
The lifeline for any business intelligence solution is the process called extract, transform, and load (ETL). According to a recent survey by The Data Warehousing Institute (TDWI), ETL design and development work consumes 60 to 80 percent of the resources of an entire BI project. Selecting an ETL solution that fits your needs is an essential first step in building a successful data warehouse.

Comments

Post a Comment

Popular posts from this blog

Should we allow our staff to use social networking sites? Some people say they are dangerous but I can't see how. Can you explain the dangers? > EXPERT RESPONSE There's nothing wrong with using Facebook, other than the potential impact on working time, but that's not a security matter! The issue is in how your staff configures Facebook, and what information they place on it. A few tips to pass on to your staff: Don't allow anyone that isn't part of your network of 'friends' to see your profile. Don't allow non-friends to see your friends. Why? I could easily impersonate one of your friends, fake a new profile, and send you an invite. You accept, thinking a genuine friend has created a new profile, then I'm in your network of friends and can see your profile. Think about what information is in your profile. What would be useful in stealing your identity? Date of birth, address, email address, employer, interests. why does this type of information n
2 comments
Read more

How to Use Chisanbop (Korean Finger Math) for Basic Addition and Counting | eHow.com

How to Use Chisanbop (Korean Finger Math) for Basic Addition and Counting eHow.com Difficulty: Easy Instructions Step 1 In Chisanbop you'll be using your two hands and ten fingers to represent numbers from 0 to 99. Start out with your hands out in front of you with closed fists. This represents 0. Each finger (not thumb) on your right hand represents 1. To represent 3, just press down three right hand fingers. Your right thumb represents 5. To represent 7, press down your right thumb and 2 right hand fingers. Think of your right hand as the ones or units place (column). Step 2 Your left hand represents the tens place (column). Each finger on your left hand is worth 10. For example, to represent 30, press down three left hand fingers. To represent 38, do the same, but also use your right hand to represent 8 as described above. Your left thumb represents 50. To represent 86, press down your left thumb and three left hand fingers for the 80, and your right thumb and one righ
Post a Comment
Read more

GIVE YOUR BRAIN A BOOST

From solving puzzles to eating the right foods, here's how to keep your grey cells in good shape. While there is no fountain of youth for the brain, there is always the next best thing. There is lots you can do right now to preserve, protect and enhance your gray matter. One hint: If you are already a devotee of a heart-healthy lifestyle, you are already on the right track. What is good for the heart is probably good for your head. And that is a great motivator! Here's food for thought's and memory. Although we are what we eat, our brains also respond to our surroundings and the activities we indulge in. Apart from foods, certain lifestyle habits too can give your brain a boost. Follow this food strategy: Keep unhealthy fats to a minimum. Sticking to a diet involving lots of fresh fruits and vegetables, a minimum of red meat, plenty of fish and the occasional red wine is very important. Brains are made up of about 60 per cent fat, but the fuel they rely on is glucose, a sim
Post a Comment
Read more