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 12683

how to handle null values in sequential file?

HCL,

1 19535

how to handle null values using transformer stage?

1 7680

how can u handle null values in transformer stage.

7 27710

What r the existing server jobs in parallalism?

ITC Infotech,

2336

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

HCL, IBM,

2821

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 12197

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 9999

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 6689

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

2 11404

specify data stage strength?

1 5234

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

2755

what is mapping lookup

1 5189

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

Cap Gemini,

2 16555

how to cleansing data

Cap Gemini,

6 17064

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between operational data stage (ods) and data warehouse?

1194

What are transforms and what is the differenece between routines and transforms?

1016

Why do you need stage variables?

1139

How do you import and export data into datastage?

1184

what is ds administrator used for?

1124

Can you explain players in datastage?

1158

Have you have ever worked in unix environment and why it is useful in datastage?

1092

What are the different type of jobs in datastage?

1006

which r the connectors used in san?

2152

Name the different sorting methods in datastage.

1002

How to clean the datastage repository?

1078

How rejected rows are managed in datastage?

1468

How can we improve performance of data stage jobs?

976

Explain ibm infosphere information server and highlight its main features?

1054

What is use Array size in datastage

1730

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