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

Data Stage Interview Questions

Questions Answers Views Company eMail

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

TCS,

6 12914

how to handle null values in sequential file?

HCL,

1 19639

how to handle null values using transformer stage?

1 7778

how can u handle null values in transformer stage.

7 28006

What r the existing server jobs in parallalism?

ITC Infotech,

2373

1.what is materialized data? 2.how to view the materialized data?

HCL, IBM,

2864

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

TCS,

7 12491

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 10199

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 6795

what is the main difference between sorragate key n primary key in one word

2 11544

specify data stage strength?

1 5361

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

2808

what is mapping lookup

1 5274

what is the diff b/w switch and filter stage in datastage

Cap Gemini,

2 16662

how to cleansing data

Cap Gemini,

6 17315

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the differentiate between data file and descriptor file?

1366

What are the different common services in datastage?

1290

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2868

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3800

Explain how a source file is populated?

1373

How to implement complex jobs in data stage?

1116

What are the different options associated with dsjob command?

1444

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1384

What is the difference between an operational datastage and a data warehouse?

1157

What is the difference between account and directory options ?

1183

Does datastage support slowly changing dimensions ?

1110

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2498

How can one find bugs in job sequence?

1424

Give an idea of system variables.

1038

What is a ds designer?

1071

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