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 12874

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

Accenture,

3 25177

when will you go for dataset and fileset?

Accenture,

2 14878

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

Accenture,

6 24638

wt is the diff b/w odbc and oracle stage

Accenture, HCL,

2 20269

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

9 15173

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

1 8008

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

IBM,

5 11282

HOW CAN WE SEE THE DATA IN DATASET?

4 11153

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

2 5965

HOW CAN WE SEE THE DATA IN DATASET?

IBM, TCS,

12 58505

why we use hash file for lookup?

5 17801

how do u capture duplicates through sort & transformer

4 18727

detail about sdlc

4 10515

what r the sources u need to create the datastage?

1 5987

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Difference between data warehousing and olap?

1089

What is a merge in datastage?

1262

Define meta stage?

1200

Can you implement SCD2 using join, transformer and funnel stage?

1549

What are data elements?

1168

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644

What is the purpose of interprocessor stage in server jobs?

2228

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

1165

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2380

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3746

What are the some differences between 7.x and 8.x version of datastage?

1253

What are the benefits of datastage?

1234

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.

3343

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2204

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

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