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

Data Stage Interview Questions

Questions Answers Views Company eMail

How can you join flat file, oracle as a sources?

IBM,

4 12891

How can you find out whether datastage process is running or not in unix?

Accenture,

3 25193

when will you go for dataset and fileset?

Accenture,

2 14898

how can i abort the job if i get more than 100 errors in job log?

Accenture,

6 24668

wt is the diff b/w odbc and oracle stage

Accenture, HCL,

2 20285

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 15215

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 8020

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

IBM,

5 11292

HOW CAN WE SEE THE DATA IN DATASET?

4 11166

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 5983

HOW CAN WE SEE THE DATA IN DATASET?

IBM, TCS,

12 58577

why we use hash file for lookup?

5 17819

how do u capture duplicates through sort & transformer

4 18742

detail about sdlc

4 10531

what r the sources u need to create the datastage?

1 5995

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is size of a transaction and an array means in a datastage?

1313

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

What are the types of containers in datastage?

1191

What is the difference between operational data stage (ods) and data warehouse?

1242

Demonstrate experience in maintaining quality process standards?

2552

Difference between data warehousing and olap?

1089

Which commands are used to import and export the datastage jobs?

1414

Explain the situation where you have applied SCD in your project?

2040

Why do we use link partitioner and link collector in datastage?

1137

Explain the importance of surrogate key in data warehousing?

1190

Define orabulk and bcp stages?

1122

Explain entity, attribute and relationship in datastage?

1101

What is the use of hoursfromtime() function in transformer stage in datastage?

1069

What are the important features of datastage?

1127

What are the different options associated with dsjob command?

1439

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