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 do you load dimension data and fact data? Which is first

2 15403

what is initial load and incremental load

ADP,

3 31894

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

IBM,

8 13763

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

Polaris,

2730

what are the errors,warnings in datastage

Syntel, Wipro,

2698

What is Fastly Changing Dimension?

TCS,

6 13988

What is RCP?

TCS,

2 10891

what are fact tables and dimension tables? give example assuming one table.

IBM,

3 8606

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24251

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

IBM,

2277

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

IBM,

1 3518

what is factless fact table?

IBM,

3 8503

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

IBM, Polaris,

3 12548

how to identifie,is it innerjoin,leftouter join in lookup?

Hexaware,

2 36181

how can we create tables in datastage?

1 12921

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Explain entity, attribute and relationship in datastage?

1102

What is usage analysis in datastage?

1307

How can one find bugs in job sequence?

1411

What is the importance of the exception activity in datastage?

1073

How can we improve performance of data stage jobs?

1017

How a source file is populated?

1066

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

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?

2213

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2230

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2261

What is the difference between in process and inter process?

1147

What is difference between server jobs & parallel jobs?

1038

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

In Datastage, how you can fix the truncated data error?

1161

what is the use of surogate key in datastage

2310

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