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 11757

how to handle null values in sequential file?

HCL,

1 19051

how to handle null values using transformer stage?

1 7237

how can u handle null values in transformer stage.

7 26477

What r the existing server jobs in parallalism?

ITC Infotech,

2166

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

HCL, IBM,

2638

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 11248

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 9195

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 6332

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

2 10885

specify data stage strength?

1 4932

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

2567

what is mapping lookup

1 4822

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

Cap Gemini,

2 16076

how to cleansing data

Cap Gemini,

6 16021


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the benefits of datastage?

927


Demonstrate experience in maintaining quality process standards?

2168


What is the difference between account and directory options ?

857


Is the value of staging variable stored temporarily or permanently?

754


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

3739


What can we do with datastage director?

902


How can we improve performance of data stage jobs?

784


What are the different layers in the information server architecture?

845


How a server job can be converted to a parallel job?

846


What is difference between server jobs & parallel jobs?

802


Describe the architecture of datastage?

773


how to export or import the jobs in .ISX file

938


What is the difference between orabulk and bcp stages?

779


what are the devoleper roles in real time? plz tell i am new to datastage....

1861


Could anyone give brief explanation bout datastage admin

2148