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 12896

how to handle null values in sequential file?

HCL,

1 19627

how to handle null values using transformer stage?

1 7769

how can u handle null values in transformer stage.

7 27982

What r the existing server jobs in parallalism?

ITC Infotech,

2371

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

HCL, IBM,

2862

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 12460

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 10187

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 6789

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

2 11529

specify data stage strength?

1 5342

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

2805

what is mapping lookup

1 5265

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

Cap Gemini,

2 16656

how to cleansing data

Cap Gemini,

6 17285

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

why do u need the IOS upgradation in a FC switch

2281

Can you explain link buffering?

1176

What are the job parameters?

1221

What is the difference between in process and inter process?

1146

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1215

What are sequencers?

1115

what is the use of skid in reporting?

2381

What are the types of containers and how to create them?

976

Can you explain kafka connector?

1311

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

Is the value of staging variable stored temporarily or permanently?

998

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2061

How do u convert the columns to rows in datastage?

1194

How do you import and export the datastage jobs?

1159

If you want to use the same piece of code in different jobs, how will you achieve it?

1152

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