Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

IBM,

3124

Explain the scenarios where sequential file stage runs in parallel?

Accenture,

3 15657

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

Accenture,

1 6768

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 7769

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000

Genpact,

5 29871

Could anyone give brief explanation bout datastage admin

2352

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

Wipro,

1 6850

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

Wipro,

1 8834

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?

SLK Software,

4 14278

which is the most complex job in your career? Please tell me answer?

IBM, Wipro,

2 7583

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

SLK Software,

5 10304

how many types of sorting the data in data stage?

BoA, IBM,

1 6931

how many types of remove the duplicate records?

Caterpillar,

3 11659

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

HCL,

1 3717

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10

Tech Mahindra,

5 10878

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2615

Define Merge?

1317

Notification Activity

1399

how to implement scd2 in datastage 7.5 with lookup stage

5605

What is difference between symmetric multiprocessing and massive parallel processing?

1141

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746

What is use Array size in datastage

1779

How to reverse the string using unix?

3509

Explain ibm infosphere information server and highlight its main features?

1091

What are the types of hashed files in data stage

1108

how to abort the job its matain duplicates?

2574

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2173

What is size of a transaction and an array means in a datastage?

1314

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

Which warehouse using in your datawarehouse

2185

For More Un-Answered { Data Stage } Questions Click Here