BeyondBGCM
asked on
SSIS 2008
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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]