IBM InfoSphere DataStage v8.5 Sample Questions:
1. How is DataStage Table Metadata shared among DataStage projects?
A) Import another copy of the table metadata into the project where it is required.
B) Export DataStage Table Definitions from one project and importing them into another project.
C) Use the "Shared Table Creation Wizard" to create a copy of the table in the shared repository.
D) Use the Import/Export Manager to move the DataStage Table Definition to the projects where it is needed.
E) DataStage Tables cannot be shared between projects.
2. What are two fundamental functions of the Information Server Source Code Integration based on the Eclipse Team framework? (Choose two.)
A) Send to Source Code Control Workspace
B) Rollback Changes
C) Commit Changes
D) Replace from Source Code Control Workspace
3. Which two of the following derivations for an output column named OutCol can be used to generate a unique sequence of integers across multiple partitions?
A) NextSurrogateKey()
B) @PARTITIONNUM + @NUMPARTITIONS
C) @INROWNUM
D) 1 + @NUMPARTITIONS * @INROWNUM
4. Which two statements are true for named node pools? (Select two)
A) Using appropriately named node pools allow the separation of buffering from sorting disks.
B) Using appropriately named node pools force DataStage jobs to use named pipes between stages.
C) Using appropriately named node pools is only available in clustered environments.
D) Using appropriately named node pool constraints limit stages to be executed only on the nodes defined in the node pools.
E) Named node pools are required for DataStage jobs to scale across multiple machines on a grid or cluster.
5. You need to find the differences between the jobs in the Test project and theit older version in the Production project. You discover that the Production project is on another domain. What feature would find the differences in a job that is in a project on a different domain?
A) Cross Domain Compare
B) Cross Project Compare
C) DataStage Version Control
D) Export from the other domain and import into a project in the same domain as the one you are working in.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A,D | Question # 3 Answer: B | Question # 4 Answer: A,D | Question # 5 Answer: B |
We're so confident of our products that we provide no hassle product exchange.


By Antonio

