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 15401

what is initial load and incremental load

ADP,

3 31887

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 13759

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 13984

What is RCP?

TCS,

2 10890

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

IBM,

3 8605

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24249

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 3516

what is factless fact table?

IBM,

3 8499

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 12546

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 }

How to find value from a column in a dataset?

2203

How to Remove Duplicate using SQL?

1364

What are system variables and sequencers in datastage

1115

What are the different types of lookups in datastage?

1054

AGGREGATOR default datatype

1460

What are the different plug-ins stages used in your projects?

1078

How many types of hash files are there?

1183

what are the errors,warnings in datastage

2698

whom do you report?

1930

Where do the datastage jobs get stored?

1216

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2967

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2446

options available in sequence job to run,validate?

1316

How can you write parallel routines in datastage PX?

1015

What are routines in datastage?

1329

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