Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

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

Cap Gemini,

5 15484

how to create document in datastage?

Cap Gemini,

1 7117

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 15687

when u face critical situation in ur project, how to solve them?

Toyota,

1 10217

explain unit testing,systemtesting,integrated testing

CSC,

1 6926

how many stages are there in Datastage... Please clarify mee??

3 8413

what is the best stage in datastage parller jobs to use full out join and why

Virtusa,

5 15926

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

Virtusa,

3 12954

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 16618

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 10313

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 22125

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

Syntel,

2 12778

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 17448

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

Syntel,

4 15354

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

What are transforms and what is the differenece between routines and transforms?

1066

Differentiate between operational datastage (ods) and data warehouse?

1178

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

2163

Explain how a source file is populated?

1366

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1500

Difference between sequential file and data set?

1201

Differentiate between data file and descriptor file?

1059

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

806

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244

How to reverse the string using SQL?

1526

Triggers,VIEW,Procedures

1220

I have a few records just I want to store data in to targets cycling way how?

2363

how to delete one row in target dataset

3122

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