The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
COURSE of the MONTH
11 days, 12 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SSIS 2008
Posted on 2014-03-29
Can you please answer below questions. please add your answer inline
Q1) In a Flat File there are millions of records. It consists of many
rejections data. Now if rejections are
a) from 0% to %25 of rejections, then continue process
b) from 25% to 40% of rejections, then Trigger a email
c) from 40% to 50% of rejections, then wait for user to respond
d) > 50% of rejections, then Abort the sequence
Q2) Suppose I want to execute a sql task before that i want to do some
job, how you will do?
Q3) Revenue Report has daily transactions of million and billions of
revenue records of different category as MMS Revenue, Internet Calling
Revenue etc. Want report of revenue received from 1 to 30 days. How to
do?
Q4) In one single flat file the data of customers are given in multiple
record. for e.g. first record has cust name, cust date
second record has cust address, cust phone
third record has cust email, cust status
How you will create one record destination from three records?
Q1) In a Flat File there are millions of records. It consists of many
rejections data. Now if rejections are
a) from 0% to %25 of rejections, then continue process
b) from 25% to 40% of rejections, then Trigger a email
c) from 40% to 50% of rejections, then wait for user to respond
d) > 50% of rejections, then Abort the sequence
Q2) Suppose I want to execute a sql task before that i want to do some
job, how you will do?
Q3) Revenue Report has daily transactions of million and billions of
revenue records of different category as MMS Revenue, Internet Calling
Revenue etc. Want report of revenue received from 1 to 30 days. How to
do?
Q4) In one single flat file the data of customers are given in multiple
record. for e.g. first record has cust name, cust date
second record has cust address, cust phone
third record has cust email, cust status
How you will create one record destination from three records?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2 Comments
This may point you in the right direction ...
Q1) I would create an Execute SQL task that directly queries the data set that is going to be returned into the flat file, and assign a value of 1, 2, 3 or 4 depending on the percentage rates. Then return the value from the SQL to a variable within the package. This way you'll have a specific indicator of which percentage range is being returned.
For example: 1 = 0 - 25%, 2 = 26 - 40%
Then use conditional logic based on the variable value (populated from the Execute SQL task) to determine which direction the process should take.
Q2) Here's an example of how to return integer values from a SQL query.
SELECT (CASE WHEN ([rejections]\[totalamount
WHEN ([rejections]\[totalamount
AND ([rejections]\[totalamount
-- and so on ..
END) AS rejectionrate
FROM [yourtable]
Q1) I would create an Execute SQL task that directly queries the data set that is going to be returned into the flat file, and assign a value of 1, 2, 3 or 4 depending on the percentage rates. Then return the value from the SQL to a variable within the package. This way you'll have a specific indicator of which percentage range is being returned.
For example: 1 = 0 - 25%, 2 = 26 - 40%
Then use conditional logic based on the variable value (populated from the Execute SQL task) to determine which direction the process should take.
Q2) Here's an example of how to return integer values from a SQL query.
SELECT (CASE WHEN ([rejections]\[totalamount
WHEN ([rejections]\[totalamount
AND ([rejections]\[totalamount
-- and so on ..
END) AS rejectionrate
FROM [yourtable]
Q3) If you are running this within an SSIS package, I would create a data flow task, use the source task to execute a stored procedure from the database, and query the 30 day period from the stored procedure. Since I don't have any table or column information to work with, I'm unable to give you an example of how to filter out that time period.
Q4) I would take this flat file, import the data into a database table, then use a stored procedure to get all of the appropriate data columns (cust name, cust date, etc.) into the proper format.
Then use a data flow task to execute a stored procedure to return the data in the proper format and use this to populate a flat file (or whichever type of destination task you would like to use to contain this data).
I hope this helps!
Q4) I would take this flat file, import the data into a database table, then use a stored procedure to get all of the appropriate data columns (cust name, cust date, etc.) into the proper format.
Then use a data flow task to execute a stored procedure to return the data in the proper format and use this to populate a flat file (or whichever type of destination task you would like to use to contain this data).
I hope this helps!
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month11 days, 12 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.