Category: DATASTAGE INTERVIEW QUESTIONS
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 …
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 …
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 …
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 …
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, …
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. …
In this DataStage scenario, we need to get the output as reverse letters in a given word. Input Data: almost big datastage etl navy Output Data: tsomla gib egatsatad …
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 join stage? Let see! …