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 you know different ways to answer that scenario problem,it would be better to explain all the ways.
Don’t try to answer in hurry, take few minutes to design your job and explain it stage by stage/draw the design on a piece of a paper.
You may face complex job scenarios also.
I am trying to gather all the DataStage scenarios and solutions for those questions.
Below I have given some of the scenarios and solutions for them. I will add some more scenarios in future.
1. Datastage Scenario Based Question – Separate Numbers And Alphabets
2. Datastage Scenario: Reverse The Word
3. Find Nth Highest Salary Group By Deptno From Emp Table In Datastage
4. Capture Unique Records (Have No Duplicates) In Datastage – Job Design – 2
5. Capture Duplicate Records In Datastage – Job Design – 1
6. Datastage Scenario Based Question – Find Candidates Who Did Not Submit Their Documents
