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 to assess your problem-solving skills by throwing scenario-based questions.
The interviewer might judge your 50% of technical knowledge by looking at your answers to scenario-based questions.
So if you know different ways (you might have more than one solution for the same problem) to answer that scenario problem, it would be better to explain all the ways or the best/optimized way.
Don’t try to answer in a hurry, take few minutes to design your job and explain the ETL job stage by stage or draw your ETL job design on a piece of paper.
Sometimes you might have to face complex ETL job design scenarios also.
So to help everyone out there who is going to attend the DataStage interviews, I am trying to gather all the DataStage scenario-based questions and solutions for them.
Below I have given some of the scenario-based questions and solutions for them. I will add few more scenarios in the future whenever I come across them.
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
Hi,
Kindly guide me to solve the below scenario,
Input Data:
1
4
2
3
Expected Output:
1
4444
22
333
Waiting for your valuable to sravan.vedala@outlook.com
It can be done by using the “str ” function in transformer “str(input, No of repeating times )”.In this case,no of repeating time will be same as input.
1. First find the Length of the string
StageVarLen = Len( Input String)
2. Use this funcation
PadString(InputStr,InputStr,StgVarLen)
what ever you are saying, is it understandable?
str(input,input)
can it be done through looping some how?
Hi,
If anyone know the answer, can you share me this mail
I have done, Let me know how can share the solution??
Well done!
Please share it here only.
vinay can u share the solution for all
please use str(input_colum,input_colum)
Two times
Please use PadString(DSLink2.Col1,DSLink2.Col1,DSLink2.Col1-1)
i have solution for this
you can use :
str(Input_column,Input_column) : it will return aspected output
or
may first find strlen=len(Input_column) in stage variable
after that use str(Input_column,strlen) function it will also give same output