Datastage Interview Question and Answers
| 51. |
Whats difference betweeen operational data stage (ODS) and data warehouse? |
| |
- A dataware house is a decision support database for organisational needs.It is subject oriented,non volatile,integrated ,time varient collect of data.
- ODS(Operational Data Source) is a integrated collection of related information . it contains maximum 90 days information.
- ODS is nothing but operational data store is the part of transactional database. this db keeps integrated data from different tdb and allow common operations across organisation. eg: banking transaction.
- In simple terms ODS is dynamic data.
|
| |
|
| 52. |
How do u convert the columns to rows in DataStage? |
| |
Using Pivot Stage. |
| |
|
| 53. |
What is environment variables? |
| |
Basically Environment variable is predefined variable those we can use while creating DS job.We can set eithere as Project level or Job level.Once we set specific variable that variable will be availabe into the project/job. |
| |
|
| 54. |
What are Stage Variables, Derivations and Constants? |
| |
- Stage Variable - An intermediate processing variable that retains value during read and does not pass the value into target column.
- Derivation - Expression that specifies value to be passed on to the target column.
- Constant - Conditions that are either true or false that specifies flow of data with a link.
|
| |
|
| 55. |
What is OCI? |
| |
If you mean by Oracle Call Interface (OCI), it is a set of low-level APIs used to interact with Oracle databases. It allows one to use operations like logon, execute, parss etc. using a C or C++ program. |
| |
|
Gk Questions with Answers