All categories

4 years ago

What does it mean to cleanse data before it is stored in a data warehouse?

1 answer:

3 0

<span>Data cleansing or data cleaning is the process of detecting and correcting corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate or irrelevant parts of the data and then replacing, modifying, or deleting the dirty or coarse data.Data cleansing is typically done before data is sent to a data warehouse.</span>

You might be interested in

Which type of comprehension focuses on who, what, where,when,why

choli [55]

Answer:

Literal Comprehension

5 0

3 years ago

Many critics have argued that a sales or consumption tax should be eliminated because of its regressive nature. what is the basi

ivolga24 [154]

The basis for this argument is that consumption tax takes a larger percentage of income from low income earners than from high income earners. This is because consumption tax is uniformly applied to all people irrespective of their situation.<span />

5 0

4 years ago

Read 2 more answers

Becoming future proof means ensuring that you _________.

poizon [28]

C) the people that purchase goods and services

4 0

3 years ago

an accounting firm collected cash on account. as a result of this transaction, total assets, liabilities, and equity are all u

musickatia [10]

TRUE, an accounting firm collected cash on account. as a result of this transaction, total assets, liabilities, and equity are all unchanged.

A legal entity is a for-profit business organization that provides professional services, such as a corporation, limited liability company (LLC), or partnership.

A firm can be a company. B. A consumer goods store that offers physical products. It can also represent a service provider such as a hairdresser. The term company can refer to any for-profit business, but it is often used to describe businesses in specific industries such as law or accounting.

Companies are all kinds of businesses. Examples of companies include sole proprietorships, partnerships, limited liability companies, and corporations. The term is more commonly associated with partnerships.

Learn more about firm here:brainly.com/question/25491204
#SPJ4

6 0

2 years ago

Dave has $100,000 to invest in 10 mutual fund alternatives with the following restrictions. For diversification, no more than $2

Over [174]

Answer:

Check the explanation

Explanation:

Let the binary variables be: x1,x2,x3.....x10. If x1=0, no amount is invested in fund 1 and if it is 1 it means that an amount is invested. Let y1,y2.....y 10 be the variables for the amount invested.

Kindly check the first attached image for the table.

The objective is to maximize the return. Hence our objective function is: 6.7%*y1+7.65%*y2+7.55%*y3+7.45%*y4+7.5%*y5+6.45%*y6+7.05%*y7+6.9%*y8+5.2%*y9+5.9%*y10. This has to be maximized.

Constraints:

(i) y1,y2.....y10<=25,000 (no more than $25,000 can be invested in any one fund)

(ii) If x1=1, y1>=10,000, 0. This what if formula will be applicable for all the variables. (If a fund is chosen for investment, then at least $10,000 will be invested in it).

(iii) x1+x2+x3+x4<=2 (No more than two of the funds can be pure growth funds)

(iv) y9+y10>=y1+y2+y3+y4 (at least as much as the amount invested in pure amount invested in pure bond funds must be at least as much as the amount invested in pure growth funds)

(v) all x's are binary and all y's>=0. (vi) y1+y2+y3+y4....y10 = 100,000 (amount to be invested)

Solving in excel using the solver function the following solution is obtained:

Kindly check the second attached image for the table.

Thus the maximum return = $7056.25

Amount invested in different funds are:

Kindly check the Third attached image for the table.

4 0

4 years ago