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 15493

what is initial load and incremental load

ADP,

3 32048

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 13984

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,

2780

what are the errors,warnings in datastage

Syntel, Wipro,

2766

What is Fastly Changing Dimension?

TCS,

6 14193

What is RCP?

TCS,

2 11023

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

IBM,

3 8753

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24403

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

IBM,

2326

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 3588

what is factless fact table?

IBM,

3 8660

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 12676

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

Hexaware,

2 36288

how can we create tables in datastage?

1 12997

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the steps required to kill the job in Datastage?

1266

Have you used Unstructured data?

1370

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1430

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5191

Name the third party tools that can be used in datastage?

1138

What are the difference types of stages?

1287

What is usage analysis in datastage?

1361

which r the connectors used in san?

2229

How we can covert server job to a parallel job?

1258

Define oconv () and iconv () functions in datastage?

1467

On which Dimension Table you implemented SCD Type in your Project

2113

What is the different type of jobs in datastage?

1030

How to find value from a column in a dataset?

2249

What is the flow of loading data into fact & dimensional tables?

1112

Differentiate between operational datastage (ods) and data warehouse?

1232

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