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 12871

how to handle null values in sequential file?

HCL,

1 19618

how to handle null values using transformer stage?

1 7761

how can u handle null values in transformer stage.

7 27949

What r the existing server jobs in parallalism?

ITC Infotech,

2369

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

HCL, IBM,

2854

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 12419

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 10169

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 6781

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

2 11514

specify data stage strength?

1 5318

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

2797

what is mapping lookup

1 5263

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

Cap Gemini,

2 16649

how to cleansing data

Cap Gemini,

6 17262

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2380

What is orabulk stage?

1045

Differentiate between validated and Compiled in the Datastage?

1268

Highlight the main features of datastage?

1157

how can we create rank using datastage?what is the meaning of rank?

8781

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

2100

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2043

What a datastage macro?

1054

On which Dimension Table you implemented SCD Type in your Project

2024

Define Merge?

1313

how many rows sorted in sort stage by default in server jobs

3995

Explain the importance of surrogate key in data warehousing?

1185

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1032

What is a folder? Difference types of stages?

1169

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2054

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