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

def getCharacterForward(char, key): """ Given a character char, and an integer key, the function shifts char forward `key` steps

zhenek [66]

Answer:

def getCharacterForward(char, key):
charList = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
if(len(char) > 1):
return None
elif(not isinstance(key, int)):
return -1
else:
index = charList.find(char)
if(index + key <= 25):
return charList[index + key]
else:
return charList[(index + key)% 26]
print(getCharacterForward("C", 4))
print(getCharacterForward("X", 4))

Explanation:

Firstly, define a charList that includes all uppercase alphabets (Line 2). We presume this program will only handle uppercase characters.

Follow the question requirement and define necessary input validation such as checking if the char is a single character (Line 4). We can do the validation by checking if the length of the char is more than 1, if so, this is not a single character and should return None (Line 5). Next, validate the key by using isinstance function to see if this is an integer. If this is not an integer return -1 (Line 6 - 7).

Otherwise, the program will proceed to find the index of char in the charList using find method (Line 9). Next, we can add the key to index and use the result value to get forwarded character from the charList and return it as output (Line 11).

However, we need to deal a situation that the char is found at close end of the charList and the forward key steps will be out of range of alphabet list. For example the char is X and the key is 4, the four steps forward will result in out of range error. To handle this situation, we can move the last two forward steps from the starting point of the charList. So X move forward 4 will become B. We can implement this logic by having index + key modulus by 26 (Line 13).

We can test the function will passing two sample set of arguments (Line 15 - 16) and we shall get the output as follows:

8 0

3 years ago

When examining the digital evidence, what stage deals with using keyword searches and file-carving utilities to locate data that

Rom4ik [11]

Answer:

The five steps of examining the digital evidence start with the policy and procedure finding, and then comes evidence assessment followed by its acquisition, and examination. And the final step is documentation and reporting. And as far as the keyword searches and file carving utilities are concerned to locate data, this is done during evidence assessment, and once keywords and file carving utilities are assessed, the final set of evidence is required in the next step. And hence the correct stage which deals with the keyword searches and the file carving utilities for locating the data is the evidence assessment.

Explanation:

Please check the answer section.

5 0

4 years ago

HELLO!!!! For instance, will we get an error if we put a space after the word “print” and before the opening parenthesis in pyth

IceJOKER [234]

In python, spaces in the sense you're talking about, dont matter. For instance,

print ( "hello") will run the same as print("hello")

But, you cannot put a space before the print statement. That's called indenting. You are only supposed to indent code that is inside loops, if-elif-else statements, and functions.

7 0

3 years ago

Four students measured the mass of a piece of metal whose accurate mass is 34.75g. Their results are 34.2g, 33.75g, 35.0g, and 3

Lilit [14]

Answer:

The given data are more precise than they are accurate

Explanation:

From the given measurements, we have;

The accurate mass = 34.75 g

The deviations from the accurate measurement is as follows;

34.2 g - 34.75 g = -0.55 g

33.75 g - 34.75 g = -1 g

35.0 g - 34.75 g = 0.25 g

34.69 g - 34.75 g = -0.06 g

For precision measurement, we find the average deviations as follows;

The sum of the deviations = -0.55 g - 1 g + 0.25 g - 0.06 g = -1.36 g

The average deviation = -1.36 g/4 = -0.34 g

For accuracy measurement, we find the average of the absolute deviations as follows;

The sum of the absolute deviations = 0.55 g + 1 g + 0.25 g + 0.06 g = 1.86 grams

The average absolute deviation = 1.86 g/4 = 0.465 g

Therefore, the magnitude of the average deviation is less than the magnitude of the absolute deviations, therefore, the given data are more precise than they are accurate

6 0

3 years ago

rite a function to prompt the user to enter the information for one movie (title, release date, mpaa rating and number of stars)

vesna_86 [32]

Answer:

import java.util.*;

public class Movie {

public static void main (String [] args) {

System.out.println(movieInfo());

}

public static String movieInfo() {

Scanner input = new Scanner(System.in);

Scanner input2 = new Scanner(System.in);

System.out.print("Enter the title: ");

String title = input.nextLine();

System.out.print("Enter the release date: ");

String releaseDate = input.nextLine();

System.out.print("Enter the mpaa rating: ");

double mpaaRating = input2.nextDouble();

System.out.print("Enter the number of stars: ");

double numberOfStars = input2.nextDouble();

return "Title: "+title+ "\nRelease Date: "+releaseDate+ "\nMPAA Rating: "+ mpaaRating+ "\nNumber of Stars: "+numberOfStars;

}

Explanation

- Create a function called <em>movieInfo()</em> that returns a string, information about a movie

- Ask the user to enter the title, release date, mpaa rating and number of stars of the movie.

- Return these values at the end of the function

- Inside the main, call the function to see the information about the movie

7 0

4 years ago