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 10634

how to handle null values in sequential file?

HCL,

1 18530

how to handle null values using transformer stage?

1 6858

how can u handle null values in transformer stage.

7 25419

What r the existing server jobs in parallalism?

ITC Infotech,

1963

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

HCL, IBM,

2412

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 10274

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 8242

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 5929

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

2 10303

specify data stage strength?

1 4620

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

2338

what is mapping lookup

1 4514

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

Cap Gemini,

2 15467

how to cleansing data

Cap Gemini,

6 15037


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How you Implemented SCD Type 1 & Type 2 in your project?

3686


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

612


Where the datastage stored his repository?

605


What is a ds designer?

631


Can you explain engine tier in information server?

642






What is the difference between account and directory options ?

611


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

1738


What is the roundrobin collector?

630


Name the different types of Lookups in Datastage?

718


Differentiate between validated and Compiled in the Datastage?

629


What is difference between symmetric multiprocessing and massive parallel processing?

645


What is the difference between Datastage 7.5 and 7.0?

663


What is the difference between in process and inter process?

658


Which warehouse using in your datawarehouse

1672


What is merge stage?

754