Category: DATASTAGE INTERVIEW QUESTIONS
As a DataStage ETL developer, you can expect a minimum of 2 scenario-based questions in any DataStage interview. This is common across all organization’s interviews. The interviewer might want …
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 …
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! …
