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,

3126

Explain the scenarios where sequential file stage runs in parallel?

Accenture,

3 15668

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 6773

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 7781

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 29887

Could anyone give brief explanation bout datastage admin

2356

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

Wipro,

1 6852

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

Wipro,

1 8837

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 14288

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

IBM, Wipro,

2 7598

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 10322

how many types of sorting the data in data stage?

BoA, IBM,

1 6935

how many types of remove the duplicate records?

Caterpillar,

3 11668

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 3726

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 10895

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between orabulk and bcp stages?

1028

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2188

Define oconv () and iconv () functions in datastage?

1417

Difference between sequential file and data set?

1209

Can you explain repository tables in datastage?

1412

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781

How to find value from a column in a dataset?

2208

What are the types of views in datastage director?

1776

What is quality stage?

992

Can we use target hash file as a lookup ?

3327

What are the functionalities of link partitioner?

1023

Explain usage analysis in datastage?

1173

How to convert RGB Value to Hexadecimal values in datastage?

4001

Which commands are used to import and export the datastage jobs?

1414

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