Series: Subject: Topic:

DataStage Interview Questions

Showing Questions 1 - 20 of 458 Questions
First | Prev | | Next | Last Page
Sort by: 

Datastage job scenario question

Asked By: premox5 | Asked On: Feb 13th, 2014

My input has a unique column-id with the values 10,20,30.....How can I get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Answered by: Muralidhar Bolla on: Apr 13th, 2014

In transformer using constraints we can achieve
1). Link--> @inrownum=1
2).link --> lastrow()
3). link --> click the otherwise condition

Answered by: premox5 on: Feb 18th, 2014

can you please explain a little bit more

Datastage scenario question

Asked By: NaveenKrish | Asked On: Feb 13th, 2014

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?

Answered by: datta on: Feb 20th, 2014

select the check box in job properties of activity 2 for "do not Check Point Run"

Answered by: premox5 on: Feb 18th, 2014

please correct me if i am wrong
if we enable "Add checkpoints so sequence is restartable on failure" means it will restart from activity 3 only right??

Datastage job scenario question

Asked By: Boopathy Srinivasan | Asked On: May 18th, 2011

Input file a contains12345678910input file b contains6789101112131415output file x contains12345output file y contains678910output file z contains1112131415how can we do in this in a single ds job in px ?....Could you please give me the logic to implement ???

Answered by: premox5 on: Jan 31st, 2014

if the input file metadata are same means you can use 1 seq file to read both the input files and then use filter stage and load it to the target files.

Answered by: Penchala Prasad on: Jan 7th, 2014

As per your scenario, we can use two sequential datset with transformer stage. In join stage properties join type use as full outer join and write the conditions in transformer as dslink11.eid <=5
dslink11.eid >5 and dslink11.eid<=10 and third condition is dslink.eid >10

What is the architecture of your datastage project

Asked By: Sam Geek | Asked On: Oct 19th, 2013

I came across this question many times in interview, in specific what can I answer..... Please help..

Answered by: Dileep J on: Jan 29th, 2014

There mainly 3 parts . 1. DS Engine 2. Metadata Repository 3. Services. If these 3 tiers installed on a single server the it will be called Single Tier architecture. If DSEngine on 1 Server and Metad...

Answered by: mona on: Dec 24th, 2013

2- tier architecture, 3- tire architecture or 4- tier architecture

How to seperate two diff datatypes and load it into two files?

Asked By: premox5 | Asked On: Jan 21st, 2014

I have a source file1 consist of two datatypes file1: no(integer) 1 2 3 & dept(char) cs it ie and I want to seperate these two datatypes and load it into target files file2 & file3. how can I do this in datastage and by using which stage?

Answered by: dileep Janga on: Jan 31st, 2014

I think this Question is to confuse the Job Aspirant by using Datatypes and all... Its very simple... File1-->2 Columns. 1.NO(Integer) 2.DEPT(Char). Target1: NO(Integer), Target2: DEPT(Char). Take ...

Answered by: Lubna Khan on: Jan 27th, 2014

In Transformer stage there is one function IsInteger and IsChar , We can identify If IsInteger (column name) then file1 else file2

What are the uses of using parameters in datastage?

Asked By: premox5 | Asked On: Dec 19th, 2013

Answered by: Lubna Khan on: Jan 27th, 2014

By Using Parameters we can avoid hardcoding and assign values at runtime

What is the exact difference betwwen join,merge and lookup stage??

Asked By: Phantom | Asked On: Jan 20th, 2006

Answered by: vij on: Jan 6th, 2014

default partition technique is Auto in all please check once

Answered by: mallika_chaithu on: 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...

How we can create rank using datastge like in Informatica.

Asked By: kishore | Asked On: Jun 5th, 2006

Answered by: Itishree on: Dec 2nd, 2013

You can use either of the below options: Seq File->Sort->Remove Duplicate ->O/P in Remove duplicate stage, choose the key column and duplicate to retain last properties Seq File->Remove Duplicate ->O/...

Answered by: Murat Nur on: Dec 28th, 2006

Hi,if ranking means that belowprop_id  rank1         11         21        32&nbs...

Dataset utility question

Asked By: amulas | Asked On: Oct 13th, 2011

How can we retrieve the particular rows in dataset by using orchadmin command?

Answered by: sunitha on: Nov 29th, 2013

orchadmin dump -part 0 -n 17 -field name input.ds

Answered by: Sushils13 on: Aug 20th, 2013

$orchadmin dump [options] Sample.ds

options : -p period(N) : Lists every Nth record from each partition starting from first record.

How to seperate repetating & non-repetating data.

Asked By: Sushils13 | Asked On: Sep 2nd, 2013

I have data in table as id 1 2 3 1 4 3 3 5 6 6 7 now I want to have output as repeatating records in one table & non-repeatating in another table table 1 : id 2 4 5 7 table 2: id 1 1 3 3 3 6 6 thanks, sushil

Answered by: bhargav on: Nov 28th, 2013

first take copy stage after take the 2 stages from copy at a time lookup and aggregater in aggregater take count -> id after filter1 count =1 out put to lookup as a reference link and stream link is copy stage again take filter2-> count=1 target1 and count<>1 target 2

Answered by: Rohit K A on: Nov 28th, 2013

Define 3 Stage Variables in Transformer Stage. StageVar1 will hold the I/P field ID values. StageVar2 hold StageVar1 Value and then write a condition in StageVar3 -> If StageVar1=Stagevar2 Then "Repea...

What are the major differences between datastage 8.1 and datastage 8.5?

Asked By: naveen.chinthala | Asked On: May 24th, 2013

Answered by: rajesh on: Oct 26th, 2013

implement looping concepts in transformer

Answered by: Seshadri B S on: Jun 19th, 2013

Last row Handling functions in transformer are additional features

Scenario based question

Asked By: Sam Geek | Asked On: Oct 24th, 2013

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

What is data quality and why it's needed ?

Asked By: singh6 | Asked On: Apr 18th, 2011

Answered by: vinay on: Oct 24th, 2013

Name cleaning
Address cleaning

Increment values based on column (looping)

Asked By: Ram_1104 | Asked On: Sep 3rd, 2013

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 ,...

Answered by: akhilesh.shivhare on: Sep 13th, 2013

yours i/p data


and o/p data



- use transformer
-define stage variable stgvar_Qty with value 1 means stgvar_Qty=1
-define loop with condition @ITERATION<=INPUTLINK.Qty
as per urs example @ITERATION<=5

- column in derivation

stgvar_Qty - Qty

there is no need to define stgvar_Qty also , use direct value 1 for column Qty

Most difficult jobs you have created

Asked By: dwhnovice | Asked On: Jun 24th, 2012

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

Answered by: Kamalakar Kalidindi on: Aug 27th, 2013

I too fed up with this question..i gave answer like this, every new job is difficult..when we are building that job for first time, it will be difficult only..among those implementing SCD type -2 (ins...

Explain datastage configuration file and its importance

Asked By: Mallikarjuna_G | Asked On: Aug 18th, 2013

Answered by: Sushils13 on: 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? 

Asked By: Interview Candidate | Asked On: Jun 27th, 2005

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

Answered by: vipul choudhary on: Aug 22nd, 2013

There are two types of hash file

1. modulus hash file- file size increases randomly
2. splitting hash file-file size decreases randomly

Answered by: Muralidhar on: Jul 29th, 2013

by default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy. String_to_date(inputdate,"%mm%dd%yyyy")

What is the meaning by oci stage ?

Asked By: ARJUN REDDY | Asked On: Sep 4th, 2011

Answered by: Sushils13 on: 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.

Answered by: Ramon on: 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?

Asked By: yaoliang | Asked On: Nov 21st, 2011

Answered by: Sushil on: 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

Answered by: glaciya on: 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 extract job parameters from a file?

Asked By: ramamulas | Asked On: Oct 27th, 2011

Answered by: Mallikarjuna_G on: Aug 18th, 2013

Write a server job routine that takes input as the file and reads the parameters from it. If the file contains more than one parameter each in a separate line, the your routine should concatenate them...

Answered by: glaciya on: Dec 13th, 2011

Could we use dsjob command on linux or unix plantform to achive the activity of extacting parameters from a job?

First | Prev | | Next | Last Page





twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.