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 15388

what is initial load and incremental load

ADP,

3 31868

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 13744

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,

2721

what are the errors,warnings in datastage

Syntel, Wipro,

2691

What is Fastly Changing Dimension?

TCS,

6 13957

What is RCP?

TCS,

2 10874

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

IBM,

3 8592

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24221

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

IBM,

2275

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 3510

what is factless fact table?

IBM,

3 8474

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 12532

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

Hexaware,

2 36171

how can we create tables in datastage?

1 12912

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Can you explain engine tier in information server?

1128

What is use Array size in datastage

1775

Explain connectivity between datastage with datasources?

970

What are the difference types of stages?

1206

What are transforms and what is the differenece between routines and transforms?

1060

Difference between in process and inter process?

1223

What are the types of views in datastage director?

1761

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

800

describe the Steps to confiure a Qlogic switch

2382

What is the difference between datastage and informatica?

1109

Define Merge?

1313

What are datastage sequences?

1116

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1531

What is the difference between odbc and drs stage?

1087

What is process model?

1966

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