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 13105

how to handle null values in sequential file?

HCL,

1 19713

how to handle null values using transformer stage?

1 7848

how can u handle null values in transformer stage.

7 28205

What r the existing server jobs in parallalism?

ITC Infotech,

2418

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

HCL, IBM,

2906

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 12716

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 10390

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 6889

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

2 11612

specify data stage strength?

1 5438

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

2858

what is mapping lookup

1 5342

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

Cap Gemini,

2 16751

how to cleansing data

Cap Gemini,

6 17452

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is active and passive stage?

1465

What are the different plug-ins stages used in your projects?

1124

How you can fix the truncated data error in datastage?

1881

What are the main features of datastage?

1350

What are the types of containers?

1310

What is the difference between account and directory options ?

1233

What is the difference between datastage and informatica?

1181

Can you define merge?

1188

Can we use target hash file as a lookup ?

3372

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3693

What is the importance of the exception activity in datastage?

1111

How do y read Sequential file from job control?

16076

options available in sequence job to run,validate?

1363

How rejected rows are managed in datastage?

1574

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2330

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