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
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)
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