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,

3117

Explain the scenarios where sequential file stage runs in parallel?

Accenture,

3 15650

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 6762

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 7754

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 29847

Could anyone give brief explanation bout datastage admin

2350

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

Wipro,

1 6847

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

Wipro,

1 8828

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 14254

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

IBM, Wipro,

2 7559

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 10294

how many types of sorting the data in data stage?

BoA, IBM,

1 6925

how many types of remove the duplicate records?

Caterpillar,

3 11639

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 3710

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 10848

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644

Can you define merge?

1116

Is possible to create skid in dim,fact tables?

2634

sed,awk,head

1459

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

800

Differentiate between data file and descriptor file?

1050

What is the difference between odbc and drs stage?

1087

On which interface you will be working as a developer?

1042

What are the primary usages of datastage tool?

1067

what is the custome stage in datastage? how can we impliment that one? plz tell me

2364

How to reverse the string using SQL?

1519

What are stage variables, derivations and constants?

1218

What are the different common services in datastage?

1277

Can you explain tagbatch restructure operator?

1169

what is flow of project?

1996

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