Category: DATASTAGE INTERVIEW QUESTIONS
A. They are persistent. B. They are indexed to improve access. C. They are compressed to minimize storage space. D. They use the same data types as the parallel …
DataStage Scenario Based Question: Candidates are filling forms in some xyz institute, they are submitting photocopy of their documents, but the documents they submit are not all the same, …
You can expect minimum 2 scenario based questions in any DataStage interview. Interviewer can judge your 50% of technical knowledge by looking at your answers for these questions. If …
As a developer, sometimes we need same dataset that should be used in another datastage server. Like it can be from Development server to Production server or Production to …
DataStage scenario based question: There is a column having both numbers and alphabet, the requirement is to separate all the numbers in one column and alphabet in other column. …
You have been working on DataStage and most of the times you have used Lookup stage for lookup data from reference link. Suddenly you heard about Sparse lookup and …
In several processing stages, you can choose or set the sort criteria (i.e. an link or “in-stage” sort). When you do that, one of those tiny “Sort” icons show …
You know it already, the Join stage doesn’t offer reject handling for unmatched records (such as in an Inner Join scenario). So how can we capture unmatched records from …
