All categories

3 years ago

Give three reasons why you think ETL functions are mostchallenging in data warehouse environment.

Computers and Technology

1 answer:

adell [148]3 years ago

5 0

Answer:

Because of the nature of the source systems ETL functions are challenging.Reasons are as following:-

1. There are various source systems are very and contrasting.

2. There is usually a requirement to deal with source systems on different platforms or Operating Systems.

3. Quality of data is uncertain in many old source systems that have developed gradually over time.

You might be interested in

How to write the algorithm to calculate the square of five numbers

ioda

Answer:

1. A = 7 and B = 12 here...

2. A^2 = 49 thus final answer will have 9 at units place and 4 is carried to add later.

3. Given number multiplied by 'B' => 127*12 = 1524

4. A*B => 12*7 = 84

5. 1524+84 = 1608 ..... ( step 3 + step 4 )

6. 1608+4 =1612 .... (4 is carried as stated in step 2)

7. Now, 16129 is the answer... (From step 2 and 6)

Explanation:

Divide the number in two parts with one part containing only the number at unit's place say part 'A', and other part say 'B', containing the remaining number.

Now square the number at unit's place. The square will be one of these; {0,1,4,9,16,25,36,49,64,81}. The unit's place digit in this square is the unit's place digit in actual final answer.Write it in the answer. If the square of digit at unit's place is a two digit no like from 16 to 81 in above set; write only the digit at unit's place from this square in the final answer and carry the remaining digit.

Multiply the actual number to be squared by part 'B'(the remaining part than the number at unit's place as described in step 1 ).

Multiply the parts 'A' and 'B'.

Add results of step 3 with results of step 4.

Add the carried digit from step 2 to the sum in prior step, that is step 5.

Now write this sum before the number we wrote at unit's place of final answer in step 2.

This number we now obtain from step 7, is the square of our number.

6 0

3 years ago

Read 2 more answers

Describe how communication strengthens relationship at work and, as a result, increases your productivity

olganol [36]

Answer:

because it helps them understand their contributions and obligations towards the organisation.

Explanation:

In an organizational setup, the need for healthy and effective communication among employees and employers is a crucial element for the overall success of the organisation. Healthy and effective communication helps in the productivity of the employees because it helps them understand their contributions and obligations towards the organisation.

Good communication improves the employees' morality and sincerity as it helps them feel responsible and as an important member of the organisation. Hence, strengthening their relationships and, as a result, increasing their productivity and efficiency.

7 0

3 years ago

Your welcome 95 points gg

STatiana [176]

Answer:

tysm :))

Explanation:

have a great day

4 0

3 years ago

Read 2 more answers

) Perform error checking for the data point entries. If any of the following errors occurs, output the appropriate error message

emmainna [20.7K]

Answer:

In Python:

entry = input("Sentence: ")

while True:

if entry.count(",") == 0:

print("Error: No comma in string")

entry = input("Sentence: ")

elif entry.count(",") > 1:

print("Error: Too many comma in input")

entry = input("Sentence: ")

else:

ind = entry.index(',')+1

if entry[ind].isnumeric() == False:

print("Comma not followed by an integer")

entry = input("Sentence: ")

else:

break

print("Valid Input")

Explanation:

This prompts the user for a sentence

entry = input("Sentence: ")

The following loop is repeated until the user enters a valid entry

while True:

This is executed if the number of commas is 0

if entry.count(",") == 0:

print("Error: No comma in string")

entry = input("Sentence: ")

This is executed if the number of commas is more than 1

elif entry.count(",") > 1:

print("Error: Too many comma in input")

entry = input("Sentence: ")

This is executed if the number of commas is 1

else:

This calculates the next index after the comma

ind = entry.index(',')+1

This checks if the character after the comma is a number

if entry[ind].isnumeric() == False:

If it is not a number, the print statement is executed

print("Comma not followed by an integer")

entry = input("Sentence: ")

If otherwise, the loop is exited

else:

break

This prints valid input, when the user enters a valid string

print("Valid Input")

Note that: entry = input("Sentence: ") is used to get input

4 0

3 years ago

When selecting font size in a document, ____ points equals one-inch-tall text?

IgorC [24]

Hello Jhigg4685


Answer: When selecting font size in a document, 72 points equals one-inch-tall text?

I hope this helps
-Chris

3 0

4 years ago