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 12896

how to handle null values in sequential file?

HCL,

1 19627

how to handle null values using transformer stage?

1 7771

how can u handle null values in transformer stage.

7 27983

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 12467

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 6789

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

2 11534

specify data stage strength?

1 5342

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 17286

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

1148

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2446

What are routines in datastage?

1329

What is apt_config in datastage?

1139

What is a ds designer?

1070

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

2062

what is repositery?

1843

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

in oracle target stage when we use load option and when we use upsert option?

2285

What are some different alternative commands associated with "dsjob"?

1169

Whats difference betweeen operational data stage (ods) and data warehouse?

1116

What are constraints and derivations?

1170

What is the difference between informatica and datastage?

1227

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3345

On which Dimension Table you implemented SCD Type in your Project

2044

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