Datastage Interview Question and Answers
| 26. |
How can we improve the performance in DataStage? |
| |
In server canvas we can improve performance in two ways - Firstly we can increase the memory by enabling interprocess row buffering in job properties
- Secondly by inserting an IPC stage we break a process into two processes.We can use this stage to connect two passive stages or two active stages.
|
| |
|
| 27. |
What is orabulk Stage? |
| |
This Stage is used to Bulk Load the Oracle Target Database. |
| |
|
| 28. |
What is APT_CONFIG in datastage? |
| |
Datastage understands the architecture of the system through this file(APT_CONFIG_FILE). For example this file consists information of node names, disk storage information etc.
APT_CONFIG is just an environment variable used to idetify the *.apt file. Dont confuse that with *.apt file that has the node's information and Configuration of SMP/MMP server. |
| |
|
| 29. |
What are orabulk and bcp stages? |
| |
These are called as plug-in stages orabulk is used when v have bulk data in oracle then v go for orabulk for other than oracle database we go for bcp stages. |
| |
|
| 30. |
Why fact table is in normal form? |
| |
A fact table consists of measurements of business requirements and foreign keys of dimensions tables as per business rules. |
| |
|
Gk Questions with Answers