Interview Questions : DataWareHouse - Part-1

What is Data Warehousing?
A data warehouse is the main repository of an organization’s historical data, its corporate memory. It contains the raw material for management’s decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems. Data warehousing collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time. It is a repository of integrated information, available for queries and analysis.

InfoSphere DataStage Client logon fails with the error: User name and/or password incorrect (80011)

When trying to logon to InfoSphere DataStage Clients (Designer, Director or Administrator) logon fails with the error: Failed to connect to DataStage server: <servername> , project: UV(User name and/or password incorrect (80011))The same user can successfully logon to the Web Console.

Cause

Unable to use Information Server due to expired passwords for WAS, xmeta or isadmin users

The following commands can be used to reset the passwords. Make sure to match these to your new passwords for the particular user. These commands should be run with the dsadm/isadmin user:

·          
                       

       Windows:

Replace the WAS administrator user/password:
<Info Server>\ASBServer\bin\AppServerAdmin.bat -was -user <new user name> -password <new password>

DataStage Error : Unable to connect with InfoSphere DataStage Clients

Problem
When connecting to InfoSphere DataStage one the following errors is received:

1. Failed to authenticate the current user against the selected Domain <Domain name>:
Could not locate the SecurityServer at host/port:/ to validate the userid and password entered. You may need to specify valid security ServerHost/Port in (WAS_INSTALL_ROOT)/properties/sas.client.props file.

DataStage FAQ1

1. What are the ways to execute DataStage jobs?

A job can be run using a few different methods:

* from DataStage Director (menu Job -> Run now...)

* from command line using a dsjob command

* DataStage routine can run a job (DsRunJob command)

* by a job sequencer

2. How to invoke a DataStage shell command?

DataStage shell commands can be invoked from :

* DataStage administrator (projects tab -> Command)

* Telnet client connected to the DataStage server