Anurag RANA

Data Warehousing Interview Questions 1) Explain some disadvantages of data ware house? These are some of the disadvantages of data ware house: - 1) It represents a very large project with a very broad scope which is a big disadvantage. 2) Upfront costs are very huge and the duration of the project from the start to the end user is significant. 3) It is inflexible and unresponsive to the departmental needs. 2) Explain about the top design? In a top design model data ware house is designed in a normalized enterprise model. This is chiefly used for business intelligence and management capabilities. Data used for business purpose and management can be met through a data ware house. It is used to generate dimensional views and is known to be good and stable against business changes. 3) Explain about the non-volatile feature of data ware house? Data once written and saved in data ware house is static and it can never be deleted and over written once confirmed. It will be

C Interview Questions 1 what is the difference between a while statement and a do statement? Ans: A while statement checks at the beginning of a loop to see whether the next loop iteration should occur. A do statement checks at the end of a loop to see whether the next iteration of a loop should occur. The do statement will always execute the body of a loop at least once. 2 what is the difference between a break statement and a continue statement? Ans: A break statement results in the termination of the statement to which it applies (switch, for, do, or while). A continue statement is used to end the current loop iteration and return control to the loop statement. 3 what does break and continue statements do? Ans: Continue statement continues the current loop (if label not specified) in a new iteration whereas break statement exits the current loop. 4 how can you tell what shell you are running on unix system? Ans: You can do the Echo $RANDOM. It will return a unde