Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

unit testing

Hi Experts,

Database having field empno,quantity,price.

my application having fields empno,qvantity, revenue.

while unit testing how can i do both.

Thanks in advance

Nihhal.

1 Solution

Accepted Solutions
nihhalmca
Specialist II
Specialist II
Author

Hi All,

Finally i understood myself by real scenario. Thanks for your support.

Regards,

Nihhal.

View solution in original post

6 Replies
Not applicable

and the question is...?

nihhalmca
Specialist II
Specialist II
Author

Database having fields empno, Qty, basic price.

application having fields empno, qty, Revenue.

my question is how can i do unit testing (having diff field revenue)

SunilChauhan
Champion
Champion

on the basis of price and quantity you can calculate revenue

use below

Revenue =Total sales - Cost of goods sold

or

revenue=total quntity* unit price - soldquntity*unit price

hope this helps

Sunil Chauhan
nihhalmca
Specialist II
Specialist II
Author

I finally got that if we have multi data sources for application

for example some tables from sql server and some tables for oracle,

we can do testing separately only (sql server table in sql server and oracle tables in oracle)

nihhalmca
Specialist II
Specialist II
Author

Hi Sunil, sorry for the reply

My intension is not formula for revenue for example some fields(tables) coming form sql server and some fields(tables) coming from oracle how can we do testing.

thanks & Regards,

Nihhal

nihhalmca
Specialist II
Specialist II
Author

Hi All,

Finally i understood myself by real scenario. Thanks for your support.

Regards,

Nihhal.