Datastage Interview Question and Answers
| 36. |
How and where you used HASH file? |
| |
HASH file is used for Lookup while populating fact table ,basically it keeps the data in buffer and use Hashing algorithm which improves the performance
of the job.It uses GENERAL or SEQ.NUM. algorithm. |
| |
|
| 37. |
What are the Repository Tables in DataStage? |
| |
- A datawarehouse is a repository(centralized as well as distributed) of Data, able to answer any adhoc,analytical,historical or complex queries.
- Metadata is data about data.
- The repository environment encompasses all corporate metadata resources: database catalogs, data dictionaries, and navigation services. Metadata includes things like the name, length, valid values, and description of a data element.
- Metadata is stored in a data dictionary and repository.
|
| |
|
| 38. |
How one source columns or rows to be loaded in to two different tables? |
| |
For Columns - We can directly map the single source columns to two different targets.
For Rows - We have to put some constraint (condition ).
|
| |
|
| 39. |
What are the types of views in Datastage Director? |
| |
There are three types of views in Datastage Director :
Job view : - Dates of Jobs Compiled.
Log view : - Status of Jobs last Run.
Status view : - Warning messages, Event messages, Program Generated messages.
|
| |
|
| 40. |
What are Sequencers? |
| |
Sequencers are job control programs that execute other jobs with preset job parameters. |
| |
|
Gk Questions with Answers