Datastage Interview Questions and Answers
21. |
What is hash file stage? |
|
Hash file stage is binary file used for lookup, for better performance. |
22. |
What is staging variable? |
|
These are the temporary variables created in transformer for calculation. |
23. |
What are Routines? |
|
Routines are the functions which we develop in BASIC Code for required tasks, which we DS is not fully supported (Complex). |
24. |
How do u convert the columns to rows in DataStage? |
|
Using Pivot Stage. |
25. |
What is merge stage? |
|
The Merge stage combines a sorted master data set with one or more sorted update data sets. The columns from the records in the master and update data sets are merged so that the output record contains all the columns from the master record plus any additional columns from each update record.
|