-
-
Scenario based question
How to find if the next value in a column is incrementing or not
for ex
100
200
300
400
If the curval greater than previous val then print greater if lesser print lesser
For ex
100
200
150
400, Here 150 -
Datastage scenario Question
A Sequences is calling activity 1, activity 2 and activity 3.while running, activity 1 and 2 got finished but 3 got aborted. How can I design a sequence such that the sequence has to run from activity 2 when I restart the sequences?
Mallikarjuna_G
- May 8th, 2014
To make the job re-run from activity 3, we need to introduce restartability in the sequence job. For this below points have to be taken care of in Job Sequence Adding Checkpoints: Checkpoints have t...
Ritwik
- Apr 21st, 2014
You have to check the " Do not checkpoint run " checkbox for activity 2. If you set the checkbox for a job that job will be run if any of the job later in the sequence fails and the sequence is restarted.
-
What is the exact difference betwwen Join,Merge and Lookup Stage??
vij
- Jan 6th, 2014
Default partition technique is Auto in all please check once
mallika_chaithu
- Jun 8th, 2011
Hope the below one helps you.Join Stage: 1.) It has n input links(one being primary and remaining being secondary links), one output link and there is no reject link2.) It has 4 join operations: inner...
-
-
-
Dataset utility question
How can we retrieve the particular rows in dataset by using orchadmin command?
sunitha
- Nov 29th, 2013
Orchadmin dump -part 0 -n 17 -field name input.ds
Sushils13
- Aug 20th, 2013
$orchadmin dump [options] Sample.ds
options : -p period(N) : Lists every Nth record from each partition starting from first record. -
-
-
-
Increment Values based on column (Looping)
I have source like this
Num, SeqNo,Ln,Qty
101, 1 ,1,5
I wanna target following below
Num,SeqNo,Ln,Qty
101, 1 , 1, 1
101, 1 , 2, 1
101, 1 , 3, 1
101, 1 , 4, 1
101, 1 , 5, 1
Based on Qty value records will be incremented.If qty value is 4 then o/p will be like below
Num,SeqNo,Ln,Qty
101, 1...akhilesh.shivhare
- Sep 13th, 2013
Yours i/p data
Num,SeqNum,Ln,Qty
101,1,1,5
and o/p data
Num,SeqNum,Ln,Qty
101,1,1,1
101,1,2,1
101,1,3,1
101,1,4,1
101,1,5,1
steps-
- use transformer
-define stage variable stgvar_Qty with value 1 means stgvar_Qty=1
-define loop with condition @ITERATION -
Most Difficult Jobs you have created
Hi Guys,
I have 3 yrs for experiences in datastage , though not much practical experience due to various reasons, now I have been asked this question in 4 of my interviews and I am always flounder at it . Have tried different approaches , telling the truth , telling a real situation I faced which actually was not that difficult , but I always seems to flounder at this question... -
Explain Datastage configuration File and its importance
Sushils13
- Aug 22nd, 2013
The Datastage configuration file is specified at runtime by a $APT_CONFIG_FILE variable. Configuration file structure Datastage EE configuration file defines number of nodes, assigns resources to ea...
-
How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]")
-
What is the meaning by OCI stage ?
Sushils13
- Aug 20th, 2013
Oracle Call Interface (OCI), it is a set of low-level APIs used to interact with Oracle databases. It allows one to use operations like logon, execute, parss etc. using a C or C++ program.
Ramon
- Sep 22nd, 2011
It is your connectivity stage object to your database. Think of it as your db stage.
-
What are the Environmental variables in Datastage?
Sushil
- Aug 19th, 2013
Basically Environment variable is predefined variable those we can use while creating DS job.We can set either as Project level or Job level.Once we set specific variable that variable will be available into the project/job
glaciya
- Dec 12th, 2011
The Environmental variables in datastage are some pathes which can support system can use as shortcuts to fulfill the program running instead of doing nonsense activity. In most time, environmental variables are defined when the software have been installed or being installed.
-
How to perform loj nd ij in lookup stage
How to perform left outer join and right outer join in lookup stage
sivaksa
- Aug 13th, 2013
You need right outer join in lookup..please change the link order like left to right, Right to left put lookup failure condition ..continue...
mallika_chaithu
- Jun 9th, 2011
In Lookup stage properties, you will have constraints option. If you click on constraints button- you will get options like continue, drop, fail and rejectIf you select the option continue: it means l...
-
Job based scenario
TABLE T1 with c1 and Table T2 with c1
1 3
2 4
2 5
3
4
5
...Dinesh
- Aug 19th, 2011
Use lookup stage...and choose reject option !
you will get the matched records in master output file(3,4,5,5) and unmatched in reject file(1,2,2,6,7). -
How did you handle an 'Aborted' sequencer?
In almost all cases we have to delete the data inserted by this from DB manually and fix the job and then run the job again.
Read Best Answer
Editorial / Best Answer
ritu singhai- Member Since Jul-2008 | Jul 5th, 2008
Have you set the compilation options for the sequence so that in case job aborts, you need not to run it from from the first job. By selecting that compilation option you can run that aborted sequence from the point the sequence was aborted.
Like for example, you have 10 jobs(job1, job2, job3 etc.) in a sequence and the job 5 aborts, then by checking "Add checkpoints so sequence is restartable on failure" and "Automatically handle activities that fail" you can restart this sequence from job 5 only. it will not run the jobs 1,2,3 and 4.
Please check these options in your sequence.
Hope this helps.Mallikarjuna_G
- Aug 10th, 2013
Two things needs to be handled when a Job Sequence aborts. 1. We must have an exception handling code that notifies us about the failure 2. When we re-run the sequence after fixing the Sequence, it ...
Riten
- May 30th, 2012
To Handle Aborted Sequence These are the steps to be taken: First Add Terminator to Job Sequence and Choose Terminator with Other option(Trigger in Job sequence) ( if job fails it will go to Other lin...
-
How to connect two stages which do not have any common columns between them?
Mallikarjuna_G
- Aug 10th, 2013
If those two stages are sources and if it is valid that though the names of columns from two sources differ but they are same, then use a copy stage infront of one source stage and rename column as pe...
muralidhar
- May 30th, 2013
This is little tricky question.we can do in two ways.
1)we can connect using lookup stage if both columns having same datatype.
2)We can add one extra column that is common for two files then we can connect.
DataStage Interview Questions
Read Best Answer
Ans