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 12898

how to handle null values in sequential file?

HCL,

1 19628

how to handle null values using transformer stage?

1 7772

how can u handle null values in transformer stage.

7 27984

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 12469

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 10188

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 6790

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

2 11536

specify data stage strength?

1 5344

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 5267

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

Cap Gemini,

2 16656

how to cleansing data

Cap Gemini,

6 17288

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Name the different types of Lookups in Datastage?

1260

Explain the situation where you have applied SCD in your project?

2040

What a datastage macro?

1060

Define ds designer?

1279

What is job control?

1112

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

How to reverse the string using SQL?

1527

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

1276

What are the job parameters?

1221

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

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

What are the primary usages of datastage tool?

1075

How complex jobs are implemented in datstage to improve performance?

1042

What is the flow of loading data into fact & dimensional tables?

1062

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