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 12692

how to handle null values in sequential file?

HCL,

1 19536

how to handle null values using transformer stage?

1 7681

how can u handle null values in transformer stage.

7 27713

What r the existing server jobs in parallalism?

ITC Infotech,

2338

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 12201

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 10002

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 6690

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

2 11406

specify data stage strength?

1 5235

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 5190

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

Cap Gemini,

2 16557

how to cleansing data

Cap Gemini,

6 17065

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

client know skid info?

2046

Terminate Activity

1244

What are the functionalities of link partitioner?

985

In Datastage, how you can fix the truncated data error?

1112

Explain usage analysis in datastage?

1111

what is the use of materialized view?

1508

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

1344

Explain the importance of surrogate key in data warehousing?

1140

Why do we use exception activity in Datastage?

1245

How we can covert server job to a parallel job?

1079

What is orabulk stage?

1000

State the difference between an operational datastage and a data warehouse?

1076

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

2418

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2160

How do y read Sequential file from job control?

15838

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