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 12643

how to handle null values in sequential file?

HCL,

1 19504

how to handle null values using transformer stage?

1 7657

how can u handle null values in transformer stage.

7 27631

What r the existing server jobs in parallalism?

ITC Infotech,

2327

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

HCL, IBM,

2811

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 12136

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 9961

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 6667

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

2 11387

specify data stage strength?

1 5218

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

2744

what is mapping lookup

1 5168

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

Cap Gemini,

2 16536

how to cleansing data

Cap Gemini,

6 17014

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2405

Give an idea of system variables.

963

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2167

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1333

What is process model?

1921

What is the difference between orabulk and bcp stages?

969

What is datastage engine?

1122

What is datastage?

1031

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1141

How do you import and export data into datastage?

1169

What is the purpose of pivot stage?

1100

What are the features of datastage flow designer?

993

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2045

What are the different layers in the information server architecture?

1079

Describe the main features of datastage?

1039

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