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 15291

what is initial load and incremental load

ADP,

3 31680

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 13444

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,

2661

what are the errors,warnings in datastage

Syntel, Wipro,

2622

What is Fastly Changing Dimension?

TCS,

6 13716

What is RCP?

TCS,

2 10711

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

IBM,

3 8469

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24071

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

IBM,

2213

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 3424

what is factless fact table?

IBM,

3 8310

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 12361

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

Hexaware,

2 36051

how can we create tables in datastage?

1 12838

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Which commands are used to import and export the datastage jobs?

1362

What are the different types of lookups in datastage?

1006

sed,awk,head

1411

Difference between data warehousing and olap?

1044

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2133

What is the difference between passive stage and active stage?

1413

I have a few records just I want to store data in to targets cycling way how?

2304

What are the types of hashed files in data stage

1060

How do you generate sequence number in datastage?

1027

What is the difference between operational data stage (ods) and data warehouse?

1179

Difference between in process and inter process?

1164

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2327

Can you explain repository tables in datastage?

1342

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1333

What are the components of ascential data stage?

1113

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